Koozali.org: home of the SME Server

URGENT - Mysql urgent problem.

cristi3k

URGENT - Mysql urgent problem.
« 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!?

cyr

URGENT - Mysql urgent problem.
« Reply #1 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 ?

cristi3k

Problem is in mysql.cnf
« Reply #2 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.

cyr

URGENT - Mysql urgent problem.
« Reply #3 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

Offline genzil

  • ***
  • 51
  • +0/-0
    • http://www.tuxx.org.uk
URGENT - Mysql urgent problem.
« Reply #4 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. :-)
Smile :-)......

cristi3k

thanx genzil
« Reply #5 on: October 19, 2005, 09:48:27 AM »
I found it, thanx all folks for the help.