Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: cristi3k on October 17, 2005, 04:45:11 PM

Title: URGENT - Mysql urgent problem.
Post by: cristi3k on October 17, 2005, 04:45:11 PM

I can not connect to mysql server from lan. How do I allow mysqlfront to connect to my server!?

Title: URGENT - Mysql urgent problem.
Post by: cyr on October 17, 2005, 05:22:02 PM

hi,

Do you see the mysql port from your client on your lan ?
Can you access the database from the server in command line or in ssh ?
Are you sure about the login,pwd used with your application ?
Do you had an incident recently with your server ?

Title: Problem is in mysql.cnf
Post by: cristi3k on October 17, 2005, 05:31:15 PM

Somewhere in mysql is a setup who says that mysql cand be accessed only from localhost.
I can not find the mysql.cnf file. That is my problem. I know how to resovle the problem. But I dont know wehere is conf file.

PS: Escuse my poor English.

Title: URGENT - Mysql urgent problem.
Post by: cyr on October 17, 2005, 07:11:51 PM

you need to create a user for those you 'll grant some priviles on your local network

exemple

Quote

[root@server html]# mysql
mysql> grant all on my_database.* to my_user@localhost identified by “password”
mysql> FLUSH PRIVILEGES;
mysql> \q

Title: URGENT - Mysql urgent problem.
Post by: genzil on October 18, 2005, 11:43:09 PM

There is two things, the first is a user with permissions to access over the network.  An example has already been provided.

The second is allowing mysql to be available on the local network.  This piece of information is availble through a search which I will leave as an exercise to the reader. :-)

Title: thanx genzil
Post by: cristi3k on October 19, 2005, 09:48:27 AM

I found it, thanx all folks for the help.