![]() ![]() The $cfg configuration directive has been removed (starting with phpMyAdmin 4.7.0) and the connection type is determined by the hostname ('localhost' uses socket connections, any IP address or hostname will use TCP/IP networking). The I presume the package keeps config files in /etc/phpmyadmin/ so you could try grepping for the word 'socket' ( grep -R socket /etc/phpmyadmin/*) to see if there is some other change there. ![]() I'm not sure if the package manager might have put in some direct reference to the socket, overriding your changes. The error message you're getting is consistent with a socket connection type, whereas you've defined a TCP/IP connection in. I wonder if your is being read the first thing I suggest trying is adding another line like die(" is being read properly") to and trying to load phpMyAdmin again you'll see the message if everything is working correctly but the login page if your is being ignored (which could mean a permission problem, it's in the wrong directory, or some other similar problem).Īssuming that is being read correctly and you're still having the problem, here are some more thoughts: USERNAME can be any user account which now will have root like access & can be remotely accessed. GRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BY 'PASSWORD'.To enable it, connect to mysql with root access, then do following queries. In this mode, root account are disabled by default for remote access. Then configure phpmyadmin config.php to listen on that server:port address. If not listening, change following line on my.cnf Allow 3306 port (or whatever port number enabled on the remote mysql server) on remote server from firewall & then check remote mysql is listening remote connections or not on the enabled port.ssh -NL 3307:localhost:3306 //pass this command to shell of the phpmyadmin server.You have to periodically check the opening of the SSH tunnel. Create an SSH tunnel to remote server MySql server & Then connect to local port.By directly I mean, not via a script or URL, but via some type of a client (which is almost always a binary/executable).You can connect to remote MySql connection in PhpMyAdmin in following two ways 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. If you are accessing MySQL via phpMyAdmin, the host field should always be - localhost. 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. 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. 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. 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. 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 |