Subject: MySQL client
Author: Linux
In response to: Grant and revoke remote root access to MySQL
Posted on: 10/26/2011 02:16:27 AM
The testing client is Heidi SQL, which is working.
>
> On 10/26/2011 02:11:30 AM Linux wrote:
To grant root access from all hosts (except for localhost):
mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY 'secret';
To revoke root access from all hosts (except for localhost):
mysql> DELETE FROM mysql.user WHERE User = 'root' AND Host = '%';
mysql> FLUSH PRIVILEGES;
References:
