[cobalt-users] re. help with Mysql

["alan@" <alan@xxxxxxxxx>]

>> have installed the MySQL package onto a RaQ 4 server.  With Telnet I have
root
>>privileges and I executed mysql_install_db and received the response
below.  I
>>have tried the following and in each case I am asked for a password and I
am
>>denigned access using the root password or leaving the password blank.

>>/usr/bin/mysqladmin -u root password "new_password"  [where new_password
is new
>>password]

>>/usr/bin/mysql -u root mysql

>>/usr/bin/mysql -u root -p mysql  [when asked I put in the root password or
leave
blank]

>>What have I missed?  Help!!

Hi mate,

Firstly, have you looked at the docs here ...
http://www.mysql.com/doc/m/y/mysql.html

They help a lot.

Secondly, you don't have to specify the user if the user is root, so

to get into the dbase admin type:
mysql -p

then it asks for the root password, (for MySQL)
type it in !

there ya go..

all else can be divined from the pages above


Cheers

Alan