Changing MySQL database password with WAMP server

Posted by: Admin  :  Category: Mysql

Linux Cpanel shared hosting: 600 GB disk space, 6 TB bandwidth, free domain, unlimited databases and ftp accounts, web hosting cheap and pro at Hostony

Linux Cpanel shared hosting: 600 GB disk space, 6 TB bandwidth, free domain, unlimited databases and ftp accounts, web hosting cheap and pro at Hostony

This little video was courtesy of a close friend and follower of Canadian Tech Online, Liz. She originally had approached me in getting Joomla! setup on her laptop for development purposes. She had recently been using it for her final thesis for University and hit a snag. All of a sudden, she was asked by the software to find a more “secure” password for her MySQL database. While changing her password to something more secure, she had inadvertantly caused an error. Before I was able to get to her computer, and see what had happened, I pointed her in the direction of th MySQL console. From that console, she was able to change her password back to the original one, restoring her site. thankfully Liz was able to do a screen record of what she did to help us all incase we run into a similar error during our site development experience. Have you ever seen an error like this? mysql error: Access Denied for user ‘root’@’localhost’ (using password = NO) I’m going to show you how to fix it. Don’t worry, it’s easy! =) How did it happen? You probably saw a message like this: Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with the default, and is open to intrusion, and you really should fix this security hole by setting a password for user ‘root’ And went and changed your password. then you got locked out and couldn’t change it back, or log into your localhost What you want to do

Linux Cpanel shared hosting: 600 GB disk space, 6 TB bandwidth, free domain, unlimited databases and ftp accounts, web hosting cheap and pro at Hostony

7 Responses to “Changing MySQL database password with WAMP server”

  1. MusicFr3aKz25 Says:

    @cdntechonline i found my password but i still get an error like saying NOPASSWORD or something like that pls help ASAP

  2. MEGAXSTU Says:

    Great tutorial thanks

  3. woddlingduckstudios Says:

    Subscribed, thanks alot bro, Ive been searching high and low to figure out how to get rid of this error, finally I find a video thats well explained, and well written. Thanks, liked this video, and subscribed.

  4. cdntechonline Says:

    @Femwest it sounds like you have set your mysql database to NO PASSWORD. that’s going to get you an error. but if it’ soffline i wouldn’t worry too much

  5. Femwest Says:

    Just a little help with this pls. i have just set up a password for MySQL. and now i get into the phpmyadmin page, and i get this error message MySQL said:

    #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.

  6. Femwest Says:

    thanks, ur video has been of great help. however i have this warning on my phpmyamin page. (Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account.) blah blah. what do i do to get rid of it.

  7. tyna02 Says:

    Great video!!! 😉

Leave a Reply

*