On 7/11/06, John Doolan <[EMAIL PROTECTED]> wrote:
Hi,
I have just installed mySQL version 5 and want to enable root access
from remote machines. However, the configuration tool fails when trying
to change the security settings with an error 2003. Apart from this it
is working fine (alongside a version 4 server on the same machine). How
do I manually enable root access from remote machines as adding "%" into
the list of hosts for root does not seem to do anything in
Administrator?
grant all privileges on *.* to root@'%' identified by PASSWORD('password');
?
--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
