Topic: MYSQL Server

[arno]

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

[MasterSleepy]

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

[arno]

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

[MasterSleepy]

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.