Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: arno on August 16, 2004, 08:42:56 AM

Title: MYSQL Server
Post by: arno on August 16, 2004, 08:42:56 AM

Lo guys,

i have a small question!

i am running a  webserver with mysql.
Now i wanna make a external mysql server on anoter pc.
I transferd all the sql data to the new sql server.
i changed the configs for my website.
instead of localhost i used 192.168.1.xx

When i try to acces my website it says cannot find dbase.
all data is the same.
all users are the same..
am i missing something?

Thnx

Arno

Title: MYSQL Server
Post by: MasterSleepy on August 16, 2004, 10:01:03 AM

Hello,

Does your external mysql server accept external connection to mysql???
You can check the connection to your mysql server with tools like mysqlfront or some things else...

Regards

Title: MYSQL Server
Post by: arno on August 16, 2004, 11:41:29 AM

i installed phpmyadmin on it,
is a way i can check this via phpmyadmin?

Title: MYSQL Server
Post by: MasterSleepy on August 16, 2004, 12:08:09 PM

You can't see that with phpmyadmin.
You can find that option in my.cnf file in /etc/

You have to create a user that can access server from anywhere or from specific IP adress.

Code: [Select]


GRANT ALL PRIVILEGES ON databasename.* TO newuser@% IDENTIFIED BY 'password';

This is to allow the user "newuser" to access database "databasename" from anywhere.

Code: [Select]


GRANT ALL PRIVILEGES ON databasename.* TO newuser@192.168.0.10 IDENTIFIED BY 'password';

This is to allow the user "newuser" to access database "databasename" from IP 192.168.0.10.

Regards.