Open phpmyadmin.config file in your WAMP>alias with either notepad or wordpad. on the second last line, replace 'deny' with 'allow'. That's all you are all set.
I just installed WAMP and started all. I had the same trouble getting into phpmyadmin. I did what you said below. MySql Server is still not accepting the connection from phpmyadmin.
@mikenku i just fail at installing alrdy i got wamp installed exactly like you just with 2.2 but when i start all services and open localhost or php...... nothing happens :(
Hi, good video, but I have a question... I already have Wamp installed and it's running and all, however in my WebPage development class, the professore mentioned something about saving the database from my Classroom's computer so I can work on it here in my laptop, I loved the idea so here I am trying but I cannot import my database here because it tells me that it cannot connect to the DB, plaese help me?
You have to open a VPN connection to the school server and connect with the database there with your school username and password. Once you have made the connection to the database it should work.
Make sure your IIs is turned off ! Go to Administrative tools, services, and find "IIS Admin" and turn it off. Then the Wamp server will be able to run and you will be able to access you PHPMyAdmin link, hope it helps
@SiiKHD i had the same problem, but if you are runing SKYPE try to log off from it (skype) then go on Start>wampserver> and click on start wampserver, after that go to the system try and click on WAMPSERVER little icone and click on PUT ONLINE. now you can go and access your phpmyadmin
@ssd841 still doesnt work =/ i run wamp on my laptop and it works fine. but i cannot get it to work. does it matter that i am running windows off of bootcamp (mac)
Ok, It WAS working fine, but now when I go to phpmyadmin I get this:
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
@Schneeblyful Try completely reinstalling MySQL, Then just do what he does in the video and nothing else, its when you set a password for something you shouldn't resulting in you not getting access.
I did something wrong, so I need to delete my schema. how do I delete one? Pressing delete doesnt helps, and right clicking it, doesnt has a delete option there. cud u help me out?
Hi, Great video! I recently moved my joomla site to a host! I downloaded wamp2.1 & practice the DB transfer & simply could not make it work locally! All i could get to show was what looked like a new installation of joomla!, & my site is 230mb is size! But when doing it in my new Cpanel it worked perfectly first time. I just created a new DB with same name, user name & password, imported the Joomla SQL table & bobs your uncle! Simple! So i have no idea why it wouldn't work for me in Wamp? lol
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
I got d problem sorted out.. Ur probably havin two local servers running or the wrong server running.. Stop the other service(apache/tomcat) and start wamp service...
hello i have a problem when ever i load wamp it shows a good portion of the half circle yellow and this is after i click connect to online (it also happens when its offline) can any one help??
hey i have a problem.When i Go to PhpMyAdmin there is an error in the site;
Error
MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
Thanks dude- Im actually half way through the vid while posting this but ive used WAMP before and it is awesome. Im trying to put WAMP5 2.0 on to my WHS PC on port 8080. but im getting: Cannot load mysqli extension. Please check your PHP configuration. But thank you for your tutorial. It was very helpful.
HEY.. I'am just starting to learn php and mysql i instaled wamp and thats about it... I'am studying "php and mysql web development" by myself i love to become a web developer and i have the faith for it but most of the the thing that i am reading in the book i can't undesrtand.. in your experience what are the first thing you need to learn to understand the concept of web development...thanks
can i install WAMP when i already have Apache, PhP, MySQL already installed, configured and running perfectly? Will there be conflict or something?...
You cant have to apache servers on the same computer they conflict, in the source code there's something you need to amend to make a server work, best bet is to use a virtual server if you want to use 2.
Unfortunately it's this one particular computer I need it to work on. Trying to get Flex3 happening really so WAMP is possibly optional. I have web servers everywhere! :-) Configuring Flex though, it seems to want it to live locally...
I am assuming you are having problems with the WAMP install is that correct? When you install wanp and go to the start menu and start it. Do you get the wamp icon in your system tray?
@mikenku I was with you until 4.16.when I click on phpmyadmin is asks for log in info.how come urs doesnt?and when I put my I.p address, it lets me in but doesnt grant me privilege to create database.Please help me out with this.ASAP!!!thanks
@mikenku I was with you until 4.16.when I click on phpmyadmin is asks for log in info.how come urs doesnt?and when I put my I.p address, it lets me in but doesnt grant me privilege to create database.Please help me out with this.ASAP!!!what is my username and pasword?and how do I gain privilege to create a new database?thanks
@mikenku@mikenku I was with you until 4.16.when I click on phpmyadmin is asks for log in info.how come urs doesnt?and when I put my I.p address, it lets me in but doesnt grant me privilege to create database.Please help me out with this.ASAP!!!what is my username and pasword?and how do I gain privilege to create a new database?thanks
@mikenku@mikenku I was with you until 4.16.when I click on phpmyadmin is asks for log in info.how come urs doesnt?and when I put my I.p address, it lets me in but doesnt grant me privilege to create database.Please help me out with this.ASAP!!!what is my username and pasword?and how do I gain privilege to create a new database?thanks
@mikenku I was with you until 4.16.when I click on phpmyadmin is asks for log in info.how come urs doesnt?and when I put my I.p address, it lets me in but doesnt grant me privilege to create database.Please help me out with this.ASAP!!!what is my username and pasword?and how do I gain privilege to create a new database?thanks
My server wouldn't start (though I crossed my fingers!) When I tried "Start Services" nothing happened. Then I tried "Put Online" and I get the error "Could not execute menu item (internal error) [Exception] Could not perform service action: The service has not been started
Open phpmyadmin.config file in your WAMP>alias with either notepad or wordpad. on the second last line, replace 'deny' with 'allow'. That's all you are all set.
suduanju 1 week ago
It wasn't working until I closed Skype ????
xXTheCscXx 2 weeks ago
403 error.......HELP!!!!!!!
MrFumanGaming 1 month ago
I just installed WAMP and started all. I had the same trouble getting into phpmyadmin. I did what you said below. MySql Server is still not accepting the connection from phpmyadmin.
What is next?
stevenkelley2010 1 month ago
@mikenku i just fail at installing alrdy i got wamp installed exactly like you just with 2.2 but when i start all services and open localhost or php...... nothing happens :(
just white screen in the browser
friebender 2 months ago
Good information but you missed to TALK about PRIVILEGES for the newbies users.
Thank you
pixelperu 3 months ago
Hi, good video, but I have a question... I already have Wamp installed and it's running and all, however in my WebPage development class, the professore mentioned something about saving the database from my Classroom's computer so I can work on it here in my laptop, I loved the idea so here I am trying but I cannot import my database here because it tells me that it cannot connect to the DB, plaese help me?
FrancisLetrasDrummer 3 months ago
@FrancisLetrasDrummer
You have to open a VPN connection to the school server and connect with the database there with your school username and password. Once you have made the connection to the database it should work.
colloredbrothers 3 months ago
4:42 wooopiiooyuuuu :D roflmao, great video btw
Tsoliassssssssssssss 4 months ago
what an ass i waste 10 minutes of my time , the most people is looking for how to set a password for mysql local with wamp ,
7lokillo 4 months ago
I like the way you say executable :D LoL
MrWant2Know 4 months ago
This has been flagged as spam show
I FOUND THAT SKYPE WAS THE CULPRIT!!! IN MY CASE....
GraphiTivity 5 months ago
Comment removed
GraphiTivity 5 months ago
Can somebody help me?
/watch?v=rlAo_DrqA9E
marcosknijnik 6 months ago
Make sure your IIs is turned off ! Go to Administrative tools, services, and find "IIS Admin" and turn it off. Then the Wamp server will be able to run and you will be able to access you PHPMyAdmin link, hope it helps
angeldark222 7 months ago
it won't open the local host. please help
codwawpc 7 months ago
When i click on phpmyadmin, it just comes up with a blank page.. What do i do?
SiiKHD 7 months ago
@SiiKHD i had the same problem, but if you are runing SKYPE try to log off from it (skype) then go on Start>wampserver> and click on start wampserver, after that go to the system try and click on WAMPSERVER little icone and click on PUT ONLINE. now you can go and access your phpmyadmin
ssd841 5 months ago 3
@ssd841 still doesnt work =/
SiiKHD 5 months ago
@SiiKHD ok, try this: make sure that the port 80 in LAN gateway (or firewall) is not used by any other program
ssd841 5 months ago
@ssd841 still doesnt work =/ i run wamp on my laptop and it works fine. but i cannot get it to work. does it matter that i am running windows off of bootcamp (mac)
SiiKHD 5 months ago
i got an error says :
Error 310 (net::ERR_TOO_MANY_REDIRECTS): There were too many redirects.
FinshFlash 7 months ago
What happens when a new version of wamp server comes out? Do I just reinstall?
GilbertHibachiArenas 8 months ago
Thanks allot Mike
TheIRaQMaFia 9 months ago
This has been flagged as spam show
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
devanferreira 9 months ago
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
devanferreira 9 months ago 14
@devanferreira try reinstalling the wamp that helped for me :)
gundeo1 9 months ago
@devanferreira i have thesame problem with you and also in apache it say it cannot find some kind of module...
rocksnyder 3 months ago
@devanferreira Click W in system tray go to MySQL then clikc my.conf or my
you should see this
#password = user_password
Remove the comment and mike it look like this
password = tonymontana
DONE
sasuke8889 2 months ago
@devanferreira open F:\wamp\apps\phpmyadmin3.4.5\config.inc.php and add your system password -
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'yoursystempassword';
it'll work
ghotalaman 1 month ago
Ok, It WAS working fine, but now when I go to phpmyadmin I get this:
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
Open new phpMyAdmin window
kingcole436 9 months ago
@kingcole436 that happens to me too. if you find a solution, could you please tell me?
Schneeblyful 7 months ago
@Schneeblyful Try completely reinstalling MySQL, Then just do what he does in the video and nothing else, its when you set a password for something you shouldn't resulting in you not getting access.
kingcole436 7 months ago
@kingcole436 k thnx mate
Schneeblyful 7 months ago
Uhhh how do you do all this without going insane?!
fivefordying2 9 months ago
how can i set a password for phpMyAdmin??
hhytyhu 9 months ago
Your wamp server dont start if you are running skype.
jeethuutube 10 months ago
How do I make this online so that other people can connect to it.
KaibaCorporationDTDL 11 months ago
why is that i received a "phpMyAdmin-Error" ... somebody help me...
airwin23quelnan 11 months ago
phpadmin have the most horrible GUI ever, i really hate it
anderzom 1 year ago
thanks m8 subed
zyboman 1 year ago
I did something wrong, so I need to delete my schema. how do I delete one? Pressing delete doesnt helps, and right clicking it, doesnt has a delete option there. cud u help me out?
chaosname1 1 year ago
When I attempt to log into phpMyAdmin, it gives me the following error.
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
What's that all about?
NPTechStudios 1 year ago
What is better wamp or xamp?
inventiontension 1 year ago
Hi, Great video! I recently moved my joomla site to a host! I downloaded wamp2.1 & practice the DB transfer & simply could not make it work locally! All i could get to show was what looked like a new installation of joomla!, & my site is 230mb is size! But when doing it in my new Cpanel it worked perfectly first time. I just created a new DB with same name, user name & password, imported the Joomla SQL table & bobs your uncle! Simple! So i have no idea why it wouldn't work for me in Wamp? lol
actrapide 1 year ago
apachetechnology(dot)net/KC/sqlsetup.aspx
sandeepgupta26 1 year ago
Setup MYSQL database using wampserver. To see the step by step setup
apachetechnology(dot)net/KC/sqlsetup.aspx
sandeepgupta26 1 year ago
Comment removed
sandeepgupta26 1 year ago
Comment removed
sandeepgupta26 1 year ago
I'm getting this error: MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: YES)
wrdeboise 1 year ago
It goes to Sourceforge and than it has been saying "Your WAMP download will start shortly" forever and ever.
KandyGirl171 1 year ago
ew. internet explorer
StumbleRockTV 1 year ago
@StumbleRockTV internet explorer is bullshit and aways has been Firefox or Safari
Actrons 1 year ago
I have problem with adminphp i click to launch and the page will run against so from nothing haven't seen Pls help my icq :594566208
SirBogdans 1 year ago
I have problem with phpadmin the page will run against so from nothing haven't seen
SirBogdans 1 year ago
great vid. try just host(one word) as hosting service. hope it helps
rubynav 1 year ago
anyone know why there is a Max: 2,048 KiB on db imports? Trying to import a WordPress db 4409kb. Is there a laymen's work-around? Thanks
MrSubdeo 2 years ago
OMFG THANK YOU. Nothing else worked but that helped alot!!!! Your the best!!!
TheSTVids 2 years ago
firefox and IE are NEVER competing.
1 star for stupid comment.
vVASuP 2 years ago
Comment removed
smudgeandzena 1 year ago
Getting error when trying to acess phpMyAdmin..
DrBuford83 2 years ago
you are getting the error because u haven't started the server if u go into your menu and click start all services then try you should get there
LoGDamo 2 years ago
@LoGDamo I tried that, and it still gives me the same error message
"cannot load mysql extension;
please check PHP configuration
Documentation"
Any other ideas???
DrBuford83 2 years ago
have you tryed uninstalling and reinstalling Wamp silly question mostlikeley but its worth a try fixes most isues
LoGDamo 2 years ago
Comment removed
tacothunder 2 years ago
Comment removed
DrBuford83 2 years ago
After downloading the WAMP and then clicking on phpMyAdmin I got this error message
"cannot load mysql extension;
please check PHP configuration
Documentation"
Has any one else received this error message, if so how can I fix it or bypass it.
DrBuford83 2 years ago
MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
What Do i Do ?...
shakanka997 2 years ago
make sure that the wamp server is on- line then try again and the options page will appear
LANTIAN314151 2 years ago
after installing wamp on my pc when i am go to localhost from my system tray it sends me to a blank page, not to datebase creation, thanks.......
ybarkawi 2 years ago
the password is left blank by befault just press enter when it ask for password you idiot
geeks rule
LANTIAN314151 2 years ago
hey dude why dont i get a wamp database creation i am getting a blank web page-all white...........not those option to create, thanks
ybarkawi 2 years ago
This contains a virus that hacks your PC !!
Zixorr 2 years ago
And where did you dream that up ? Or was that just a statement you made because you don't have a lue what the tut is about ?
michaelball123 2 years ago
I lol'd. Anyone who is watching this is probably trying to learn...I have not the slightest idea how this retard got to this vid
89Valkyrie 2 years ago
fucking geeks
Zixorr 2 years ago
Comment removed
89Valkyrie 2 years ago
This has been flagged as spam show
Checkout my MYSQL Brute Force
watch?v=dMIjDgWbF98
L2DragonHunter 2 years ago
does it work on vista 64 bit
hilan19 2 years ago
dosnt work for me either beause i need a password dont ask why it just asks for a password
emtonstiLord 2 years ago
doesnt work for me :-(
acesamped 2 years ago
You need to rename this tutorial: Creating database WITH WAMP.
I want to learn how to write it in MySQL, not using someone's premade how-to for 6 year olds.
kainestolkyn 2 years ago
wamp wont allow me to import. i tried making the files smaller. but its just not working, even after reinstalling it. ~_~ its killin me
RealThero 2 years ago
Databasing? Is this a new technical term?
JamesMorlan 2 years ago
nope
cowfucker99 2 years ago
Can you import CVS Database Files...
CaptainEquitable 2 years ago
when i click on phpMyAdmin, it redirects to scour and says page not found.. Can you help me.. I'm using firefox on windows vista..
shaveensk 3 years ago
same
SpireKamical 2 years ago
I got d problem sorted out.. Ur probably havin two local servers running or the wrong server running.. Stop the other service(apache/tomcat) and start wamp service...
shaveensk 2 years ago
Comment removed
mectoonTube 3 years ago
hello i have a problem when ever i load wamp it shows a good portion of the half circle yellow and this is after i click connect to online (it also happens when its offline) can any one help??
nick93us 3 years ago
How do I MAKE tables?
baileyraetsen 3 years ago
CREATE TABLE tablename (
-- fields go in here
);
Basic syntax for creating tables in SQL
jsmith19810808 2 years ago
hey i have a problem.When i Go to PhpMyAdmin there is an error in the site;
Error
MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
lourenz1230 3 years ago
if you google
wamp phpmyadmin error #1045
you can find some answers. try hitting the refresh button on your browser. that's what did it for me.
SpicerHomeMovies 3 years ago
You probably set a root password for your SQL server.
jsmith19810808 2 years ago
oci.dll not foung any help?
rtrxggg 3 years ago
Thanks dude- Im actually half way through the vid while posting this but ive used WAMP before and it is awesome. Im trying to put WAMP5 2.0 on to my WHS PC on port 8080. but im getting: Cannot load mysqli extension. Please check your PHP configuration. But thank you for your tutorial. It was very helpful.
electricdude107 3 years ago
thats because there are conflicts with older php_mysqli.dll files, try deleting the others, also deleting old enviroment variables paths.
also some people fix it replacing it with new downloaded dlls.
neoideo 3 years ago
hey when i press phpMyAdmin website doesnt open but it says cannot find webpage
xwesnaa 3 years ago
probably because you need to open wamp and click on 'start all services' in the right click menu.
gasbag15 3 years ago
Great video man
Fabianv 3 years ago
This is really useful.
Where's the next vid in the series though please?
dalenewton 3 years ago
I got the same problem - its says Phpmyadmin page cannot be shown - with this discription:
Not Found
The requested URL /phpmyadmin/ was not found on this server.
Apache/2.0.63 (Win32) PHP/5.2.5 Server at localhost Port 80
Any help?
Tr4ncehe4d 3 years ago
I click on PhpMyAdmin and then it says that the page couldnt show, plz help!
YunaQQQQQ 3 years ago
HEY.. I'am just starting to learn php and mysql i instaled wamp and thats about it... I'am studying "php and mysql web development" by myself i love to become a web developer and i have the faith for it but most of the the thing that i am reading in the book i can't undesrtand.. in your experience what are the first thing you need to learn to understand the concept of web development...thanks
llandyoa 3 years ago
Greets
I love web design.
I'm thinking the first probably is HTML+PHP+SQL
HTML for Mark-up language (structure of contents on a web site) Php for Side server... processing data functions across a web server.
And SQL for database management/MySQL
Php and SQL works together, communicates with eachother. Also learn Javascript to enhance HTML contents. PHP and SQL are pretty damn easy.
I suggest switching to linux, ubuntu server 7.2 and install lamp.
If you have any questions pm me
Session01Hijack 3 years ago
This helped a great deal, thanks!
tarantina 3 years ago
LGzCnj731QkpOkcphQM7k9
no shame no fame, check it out, sultry and bored chick here
OGEQot2SCSAQch6E9NrVeS0poE7So
Carlimongrel1910 3 years ago
thx i was killing with my server know i doing a lot better.. thx very helpful for me.
arkilium 3 years ago
Que:
can i install WAMP when i already have Apache, PhP, MySQL already installed, configured and running perfectly? Will there be conflict or something?...
Tnx
jpgen01 3 years ago
Probably, but why would you want to???
hccrle 3 years ago
Probably, but why would you want to???
hccrle 3 years ago
You cant have to apache servers on the same computer they conflict, in the source code there's something you need to amend to make a server work, best bet is to use a virtual server if you want to use 2.
jsmith19810808 2 years ago
will this help me at all with creating a WoW server?
Danman429 3 years ago
great video quality. and this helps alot, thanks!
reborn2603 3 years ago
ok dude, this looks nice, but umm.. THE SITE IS IN A DIFFERENT LANGGUAGE! ok whatever,ill try to translate it
melapnt 3 years ago
Hey Mike,
Great video! Thank you so much.
Is it possible to get the sql code to create the wiki?
bitwyse1 3 years ago
I click phpMyAdmin and nothing happens. It says it is forbidden? What is going on?
orochitaco 3 years ago
Comment removed
smokenfly514 2 months ago
i had the same problem, if you use Vista you need another Wamp called : Wampserver2.
MeirSimhi 3 years ago
Yes, the icon is there, but when I try to start it, it gives me the error I described earlier. You wanna take this in email? :-)
david102299 3 years ago
Unfortunately it's this one particular computer I need it to work on. Trying to get Flex3 happening really so WAMP is possibly optional. I have web servers everywhere! :-) Configuring Flex though, it seems to want it to live locally...
david102299 3 years ago
I am assuming you are having problems with the WAMP install is that correct? When you install wanp and go to the start menu and start it. Do you get the wamp icon in your system tray?
mikenku 3 years ago
@mikenku I was with you until 4.16.when I click on phpmyadmin is asks for log in info.how come urs doesnt?and when I put my I.p address, it lets me in but doesnt grant me privilege to create database.Please help me out with this.ASAP!!!thanks
f4frank 1 year ago
@mikenku I was with you until 4.16.when I click on phpmyadmin is asks for log in info.how come urs doesnt?and when I put my I.p address, it lets me in but doesnt grant me privilege to create database.Please help me out with this.ASAP!!!what is my username and pasword?and how do I gain privilege to create a new database?thanks
f4frank 1 year ago
This has been flagged as spam show
@mikenku @mikenku I was with you until 4.16.when I click on phpmyadmin is asks for log in info.how come urs doesnt?and when I put my I.p address, it lets me in but doesnt grant me privilege to create database.Please help me out with this.ASAP!!!what is my username and pasword?and how do I gain privilege to create a new database?thanks
f4frank 1 year ago
This has been flagged as spam show
@mikenku @mikenku I was with you until 4.16.when I click on phpmyadmin is asks for log in info.how come urs doesnt?and when I put my I.p address, it lets me in but doesnt grant me privilege to create database.Please help me out with this.ASAP!!!what is my username and pasword?and how do I gain privilege to create a new database?thanks
f4frank 1 year ago
This has been flagged as spam show
@mikenku I was with you until 4.16.when I click on phpmyadmin is asks for log in info.how come urs doesnt?and when I put my I.p address, it lets me in but doesnt grant me privilege to create database.Please help me out with this.ASAP!!!what is my username and pasword?and how do I gain privilege to create a new database?thanks
f4frank 1 year ago
My server wouldn't start (though I crossed my fingers!) When I tried "Start Services" nothing happened. Then I tried "Put Online" and I get the error "Could not execute menu item (internal error) [Exception] Could not perform service action: The service has not been started
Sure wish this worked but YMMV as usual!
david102299 3 years ago
Try another computer - see what happens - this will eliminate computer errors - need to trouble shoot - do the easy stuff first.
mikenku 3 years ago
:( i try localhost
and it shows up blank...not a not available error...but just blank
same with the phpmyadmin
Killingcheese 3 years ago
Try reinstalling - make sure the server is turned on from the start menu. If it doesn't work send me a few more details.
Best,
Mike
mikenku 3 years ago
nice one...
rne1223 3 years ago