RE: Root pass

Hi

Not sure here, but you have logged in as 'admin' on the system. Unless you
su to root mysql will use the same user.

try either

[admin admin]$ su -l

to log in to the system as root and then 'mysql -p' to log into mysql

or stay as admin but log into mysql as root, under mysql

[admin admin]$ mysql -u root -p


The clue is in the line

ERROR 1044: Access denied for user: '@localhost' to database 'mysql'

which would read 'root@localhost' if you were logged in as root

HTH, if not come back to me

Peter

-----------------------------------------------
Excellence in internet and open source software
-----------------------------------------------
Sunmaia
www.sunmaia.net
info@xxxxxxxxxxx
tel. 0121-242-1473
-----------------------------------------------

> -----Original Message-----
> From: Page Works Web Solutions [mailto:ceo@xxxxxxxxxxxxxxxxx]
> Sent: 30 June 2002 08:14
> To: mysql@xxxxxxxxxxxxxxx
> Subject: Root pass
>
>
> Hi all,
>    Yet another 3am night and I still can't get my MySql to work.  I
> installed MySql on a cobalt Raq 4 server running Linux.  I can telnet into
> the mysql directory, but can not seem to change the root pass.  I've
> searched every place except the one that as the answer to my
> question. What
> am I doing wrong.  Below is the session if you can help.
>
>
>
> [admin admin]$ mysql
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 16 to server version: 3.23.37
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer
>
> mysql> show databases
>     -> ;
> +----------+
> | Database |
> +----------+
> | mysql    |
> | test     |
> +----------+
> 2 rows in set (0.00 sec)
>
> mysql> use test;
> Database changed
> mysql> use mysql;
> ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
> mysql> bin/mysqld -Skip-grant
>     -> USE mysql;
> ERROR 1064: You have an error in your SQL syntax near
> 'bin/mysqld -Skip-grant
> USE mysql' at line 1
>
>
>
> Thanks in advance for any help.  :)
> Shawn
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread113417@xxxxxxxxxxxxxxx>
> To unsubscribe, e-mail
> <mysql-unsubscribe-peter=sunmaia.net@xxxxxxxxxxxxxxx>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread113418@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail 
<mysql-unsubscribe-gcdmg-mysql=m.gmane.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php