Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: DaveTas on June 10, 2005, 11:03:05 AM

Title: MySQL Administrator Access Problem
Post by: DaveTas on June 10, 2005, 11:03:05 AM

Hi Folks,

I want to use MySQL Administrator Win32 GUI on local network only (have firewall blocking incoming 3306)

I have done ;
/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
/etc/rc.d/init.d/mysqld restart

Now Administrator connection errors with;
Access denied for user root@pc-00003.mydomain etc

I think I have to set permissions somewhere - but where..

mysql_setpermission seems to exclude admin privs..

Title: MySQL Administrator Access Problem
Post by: psdata on June 10, 2005, 03:24:15 PM

At the first Dave Welkom in the World off "SME"

You have right you must make on the MySql database a new user (or root) who can acces the database remote.

You search at the Mysql Site for the right infomation, but here follow's the commands you can enter

go whith a telenet session to the root prompt off your server gif the command "mysql" you get a new prompt of the mysql server

And gife the following string

Code: [Select]


grant all privileges on *.* to mysqladmin@'%' identified by 'password';
flush privileges;  

Now you have made a new user whith (mysaladmin) whith all right on all databases from only local are remote station. You can also change mysqladmin@'%' whith mysqladmin@pc00xx. so only your station can run the admin tool.

Use these account to managing the database's if you made a web application whith MySql make a user whith only rights on that database and gife that account only localhost acces.

Code: [Select]


grant all privileges on application.* to application@localhost identified by 'password';
flush privileges;
 

Disable a few richts after whith your mysql admin tool so the application is running and nothing more.

A other very good solution is to install phpMyAdmin you find it in the contribs downloads, it's a Mysql administrator whitch is webbased. (search for that on these forum)

Regards

John

Code: [Select]