* Aaron Gerber > I'm new to the list, hope this is the correct mailing list.
It is. :) > I have a new installation of MySQL 4.0.16. Default binary installation > (apt-get). It's running on linux (morphix .4). > > Locally, I can connect to the MySQL server > > mysql -h localhost -p You are not using the -u parameter. The user you are logging in with will be the user of your current linux session. root? > I can also connect through phpmyadmin (remotely or locally). > http://xxx.168.xxx.xxx/phpmyadmin/ This is a different type of connection. A web server is running on xxx.168.xxx.xxx, phpmyadmin is installed on it. You are connecting to the web server with your browser. > but I can't connect if I put in the IP address (locally or remotely) > > mysql -h xxx.168.xxx.xxx -p > password: > ERROR 2003: Can't connect to MySQL server on 'xxx.168.xxx.xxx' (22) --- > locally > ERROR 2003: Can't connect to MySQL server on 'xxx.168.xxx.xxx' (61) -- > remotely You don't use the -u parameter. This means the current user name is used. Did you try this logged in to linux as a user named xxxxxxx? (Where 'xxxxxxx' is the name you have defined in phpmyadmin) > I've looked all through the documentation from MySQL and the archives > on the web. From looking at the docs, it seems that my problem either > lies in how the user accounts are set up for how the server is set up. > My guess is the user accounts. I've set up the user to be able to > connect from anywhere. Summary(user: xxxxxxx, host: %, password: Yes, > privileges: ALL PRIVILEGES , grant: Yes). I used phpmyadmin to set up > the accounts. With this setup, the user xxxxxxx should be able to log in from any host, but you should use "-u xxxxxxx" when you start the mysql client: mysql -h xxx.168.xxx.xxx -u xxxxxxx -p Note that there are two ways to connect to the mysql server: using sockets (or named pipes on windows) or using TCP/IP. If you provide "-h hostname-or-ip-address" a TCP/IP connection is used, if you provide "-h localhost" or no -h parameter, a unix socket is used. You are not running the server with "--skip-networking", are you? If you are, TCP/IP support is disabled. Have you configured the server to use a non-standard port (different from 3306)? In that case, you must provide port number when starting the client: mysql -h xxx.168.xxx.xxx --port=3307 -u xxxxxxx -p <URL: http://www.mysql.com/doc/en/Can_not_connect_to_server.html > -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
