I see 2 possible problems:
1) syntax: I had to experiment with the mysql line a bit before
it worked. Try:
mysql -urknop -p
password
(Note no space before username, password last)
2) Your user has no permissions at all: I've never tried that, but
I wouldn't be surprised if it made login impossible. Try setting a
few first.
Good luck!
Steve
Robert A. Knop Jr. wrote:
> OK, I think I've read the docs and am doing everything right, but I simply
> cannot get the "mysql" program to accept a password for any user other than
> root.
>
> I'm on RedHat Linux 7.2, with MySQL version 3.23.46.
>
> I can get the root password set up fine, and I log in with it. I can even
> change it:
>
>
> mysql> set password for root=password('newrootpw');
> mysql> \q
>
> shell$ mysql -p -u root
> Enter password:
>
> Welcome to the MySQL monitor. Commands end with ; or \g....
>
> So far so good. Next I try to create another database and another user.
>
> mysql> create database rknop;
> Query OK, 1 row affected (0.00 sec)
>
> mysql> grant all on rknop.* to rknop identified by 'testpw';
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> \q
>
> Here's the problem:
>
> shell$ mysql -p -u rknop rknop
> Enter password:
> ERROR 1045: Access denied for user: 'rknop@localhost' (Using password: YES)
>
> I've also tried (as root in mysql)
>
> mysql> set password for rknop=password('testpw');
>
> To no avail. For reference, the user table has:
>
> mysql> select * from user where user='rknop'\G
> *************************** 1. row ***************************
> Host: %
> User: rknop
> Password: 12ab181d57a7f4be
> Select_priv: N
> Insert_priv: N
> Update_priv: N
> Delete_priv: N
> Create_priv: N
> Drop_priv: N
> Reload_priv: N
> Shutdown_priv: N
> Process_priv: N
> File_priv: N
> Grant_priv: N
> References_priv: N
> Index_priv: N
> Alter_priv: N
> 1 row in set (0.00 sec)
>
> The /var/log/mysqld.log file says nothing after the startup "ready for
> connections" message, and as such can shed no light on the situation.
>
> Can anybody offer me any suggestions as to how to get around this
> predicament?
>
> Thanks,
>
> -Rob
>
> ---------------------------------------------------------------------
> 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 <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
--
Steve Rapaport
World Citizen
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
