| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 75754 | 2007-01-09 05:00:00 | MySQL on network | jcr1 (893) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 514142 | 2007-01-09 05:00:00 | I am trying to set up Heidi SQL (which looks very much like replacement for MySQL-Front), and, I get this error message; "Could not establish connection. Details: SQL Error: #HY000host '192.168.1.12' is not allowed to connect to this MySQL server." 192.168.1.12 is the address of the server where I have installed MySQL, and it works fine at the command line; but a front like this would be easier. I have followed a Debian tutorial so far but this last bit has me stumped. 192.168.1.13 is the address of the windows machine where I want to work from. Anyone got any ideas? |
jcr1 (893) | ||
| 514143 | 2007-01-09 05:07:00 | you will need to find bind-address in /etc/mysql/my.cnf and change it to 192.168.1.12. it will be 127.0.0.1 at the moment | Dannz (1668) | ||
| 514144 | 2007-01-09 06:51:00 | Thanks DanielF, I've already done that. Should've mentioned. |
jcr1 (893) | ||
| 514145 | 2007-01-09 06:51:00 | Moving too fast here. Still doesn't work. | jcr1 (893) | ||
| 514146 | 2007-01-09 07:15:00 | Check the account you are using to login to the server and make sure it can login from any IP address or that it is allowed to login from the IP address of the client. | ughnz (8297) | ||
| 514147 | 2007-01-09 07:29:00 | Check the account you are using to login to the server and make sure it can login from any IP address or that it is allowed to login from the IP address of the client. Thanks, but I'm a bit perplexed here. Could you give me a bit more detail about the login account? |
jcr1 (893) | ||
| 514148 | 2007-01-09 07:31:00 | It is the SQL account you are using on the windows PC to connected to the server. | ughnz (8297) | ||
| 514149 | 2007-01-09 07:52:00 | It is the SQL account you are using on the windows PC to connected to the server. You will be putting a username and password into the client. By default the root account cannot connect from any host. you will need to make an account (you will have to look up the sql syntax) |
Dannz (1668) | ||
| 514150 | 2007-01-09 20:54:00 | Thanks, but I'm still a bit perplexed. Here's some output from 192.168.1.12. Bearing in mind I want to connect from 192.168.1.13:confused: mysql> SHOW GRANTS FOR root; +------------------------------------------------------------------------------- --------------+ | Grants for root@% | +------------------------------------------------------------------------------- --------------+ | GRANT SELECT, INSERT, UPDATE ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '5d2e19393cc5ef67' | +------------------------------------------------------------------------------- --------------+ 1 row in set (0.01 sec) mysql> |
jcr1 (893) | ||
| 514151 | 2007-01-09 22:20:00 | What version of MySQL are you using on the server? Do you have a firewall on the server, if so check you have opened the port up for MySQL. It could be a password hash issue, i.e. the front end is generating a long hash password where as the password you have is a short hash password. See if the front end has an option to use MySQL v3 style passwords and try that. |
ughnz (8297) | ||
| 1 2 | |||||