Database Passwords
Posted by:
Ken Smith
Date: April 29, 2016 07:29AM
Hi This seems a daft question as I'm not a MySQL newbie but this is a newbie question.
I enter as follows
create database TTX_ASA;
GRANT ALL PRIVILEGES on TTX_ASA.* to 'ttx_asa'@'%' IDENTIFIED BY '*******';
flush privileges;
Where ******* is the password
when I try to access the database I get
mysql -uttx_asa -p TTX_ASA
Enter password:
ERROR 1045 (28000): Access denied for user 'ttx_asa'@'localhost' (using password: YES)
Whereas I have another database on the same server that works fine
like this
mysql -uttx_cjc -p TTX_CJC
and it works just fine
I can't believe that TTX_ASA is a special name to MySQL and somehow not usable as I have used it on another machine without problems.
I have dropped the database and re-created it. Should I backup all the databases, wipe them and start again?
This is on Centos 6
Any suggestions welcome
Thanks
Ken
Subject
Written By
Posted
Database Passwords
April 29, 2016 07:29AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.