Re: Root pass

Hi shawn,
You have probably have % in the user and host of the user table, so mysql
client let you in without a username. To be able to use mysql database, you
have to login as the root user. Just type, mysql -u root -p and see if you
can login in that way.
  Besides, you have to restart mysqld from your unix shell prompt, you can't
do it inside the mysql client ..
  I hope this helps,
  Gurhan
----- Original Message -----
From: "Page Works Web Solutions" <ceo@xxxxxxxxxxxxxxxxx>
To: <mysql@xxxxxxxxxxxxxxx>
Sent: Sunday, June 30, 2002 3:14 AM
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-ergenekon=starpower.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-thread113422@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail 
<mysql-unsubscribe-gcdmg-mysql=m.gmane.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php