By directly I mean, not via a script or URL, but via some type of a client (which is almost always a binary/executable). The only time you'd use another domain-name, host-name, or IP for host: is when you are accessing MySQL directly from another system. As phpMyAdmin is on the same system MySQL is. Left-click on the WAMP icon and click on 'Localhost'. Now that WAMP is running, let see if it is working. Left-click button menu display WAMP - Right-click button menu display. Each menu can be accessed either by left-click button or right-click button on the icon in the taskbar. If you are accessing MySQL via phpMyAdmin, the host field should always be - localhost. WAMP has two menus for config, settings and tools. phpMyAdmin web application appears listing some of the tables already created in your wamp server on the left side of the window. In this case, the host field will always be in relation to the location of MySQL, not to the system phpMyAdmin is being accessed from. Create a new Database Go to localhost/phpmyadmin in the browser or click Admin button of MySQL module and create a new Database. I filled username field with 'root' and host field with my computer 2 IP address and left password field with "no password" and checked all Global privileges for my user. 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. If phpMyAdmin is not set up via an Alias (it is under WampDeveloper, not sure about other WAMPs like Xampp or WampServer), but is rather just a dump of its files in a DocumentRoot (website's webroot) sub-folder, check the. It possibly will have these lines in it - Īdd another allow from IP.Address line in it to match the IP.Address of your other LAN system. Where a MYSQL account has 2 parts seperated by an symbol username domain. username root password YOURNEWPASSWORD Also, remember there are actually 3 root user accounts setup in a default WAMPServer MYSQL installation. Your issue is with Apache's configuration, or more specifically your WAMP's configuration of the /phpmyadmin URL.įind the configuration file where the \phpmyadmin URL Alias is set up. This will tell phpMyAdmin to throw a login screen where you can enter the. That error message has more to do with Apache blocking access, than with phpMyAdmin, or the MySQL user account created.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |