How to configure mysql server?

[Timothy Murphy]

CodeHeads wrote:

> On Thu, 22 Jun 2006 03:42:30 +0100 Timothy Murphy
> <tim at birdsnest.maths.tcd.ie> wrote:
> 
>> I'd like to run mysqld on my desktop "alfred"
>> and run a mysql client on my laptop "elizabeth".
>> 
>> It seems I need to grant permission on alfred
>> for tim at elizabeth to access the server,
>> but I have not found how to do this.

> Try this:
> $ mysql -u root
> 
> As a default root does not have a password. You have to change the root
> password after you install it the first time.

[tim at alfred ~]$ mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
[tim at alfred ~]$ su
Password:
[root at alfred tim]# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
[root at alfred tim]#


-- 
Timothy Murphy  
e-mail (<80k only): tim /at/ birdsnest.maths.tcd.ie
tel: +353-86-2336090, +353-1-2842366
s-mail: School of Mathematics, Trinity College, Dublin 2, Ireland