> -----Original Message-----
> I was trying to connect into an MYSQL database, and I keep
> getting the error
> message
>
> Can't connect to MySQL server on '10.10.10.250' (10054)
>
> but I know that the database is running and I can connect
> fine on the server
> itself!
>
> Any suggestions would be greatly appreciated.
You probably have only granted permission, for the user you are connecting as, to the
localhost where MySQL is installed
use mysql;
SELECT * FROM user\G
This will show all users able to connect to mysql server and from what host address.
Check the ip of the computer you are connecting from and see if it in there.
If not, try:
GRANT <some privileges> on <database>.<table> to '<username>'@'10.10.10.%' identified
by '<password>';
^^^
can be wildcard *.* or <database>.*
Check the GRANT section in the mysql manual.
If you are connecting to the server from windows, you may want to use the -u option,
which is the user name on the mysql server, just incase your windows username does not
match
: mysql -u username
hmm, what else... try that for now
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
