![]() Or or Then make sure you change all 3 account to have the same password so this does not trip you up later. ![]() Where a MYSQL account has 2 parts seperated by an symbol username domain you have changed the password on only one of these make sure you are logging in using the same using the correct URL like so :. This will tell phpMyAdmin to throw a login screen where you can enter the username = rootĪlso, remember there are actually 3 root user accounts setup in a default WAMPServer MYSQL installation. Personally I dont like this method as you have to hard code the password into a php file that theoretically anybody could see.Įdit the \wamp\apps\phpmyadmin4.1.14\ file and make these 2 changesįrom //$cfg = 'cookie' To create a database, click Databases in the main navbar at the top. Do not delete these, as they are necessary for WampServer and phpMyAdmin to run properly. The run phpMyAdmin left click wampmanager icon -> phpMyAdminĪnd you should be automatically logged in. On the left is a list of databases that already exist: informationschema, mysql, performanceschema, and test. Restart the Apache server :- left click wampmanager icon -> Apache -> Service -> Restart service Its the file that tells Apache, amongst other things, to refer to a specific directory when a user calls for the alias phpmyadmin. There are 2 ways to do this, well there are more than 2 ways but lets keep it simple for now.Įdit the \wamp\apps\phpmyadmin4.1.14\ file and find this lines $cfg = '' Ĭhange this lines to include your new password $cfg = 'YOUR_NEW_PASSWORD' ![]() Select the User accounts tab, which reveals that no password is set for. So if you used phpMyAdmin and changed the password for the root userid then of course you have to tell phpMyAdmin the password when you try and login next time. Setting Up Apache-MySQL/MariaDB-PHP (AMP) on Linux (LAMP), Windows (WAMP) and. You are not creating a server when you create a database. Ok I think this is just a terminology problem, but lets start by getting a few things straight.įirst phpMyAdmin is a tool for maintaining a MYSQL database. First check if your MySQL is bind to localhost or any host (0.0.0.0 or ) If its already bind to any host, the next would be to see if your firewall/router is allowing the port, you might need to do a port forwarding on your router. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |