I have some problem in configuring mysql.
I want to import a database to mysql.
Those databases are in XML and to convert them to sql and integrate, I have
a software (BioWareHouse).
That software requires the username with its password and the database name
to which the sql files should be imported as arguments.
So i created a new user with a password and gave full previleges for that
user to that database.
Then, when i attempt to login that user with password in the command line
with the following command:
[rajagopal@ramak3 ~]$ mysql -u biowareuser -p bioware
Enter password:
ERROR 1045: Access denied for user: 'biowareuser@localhost' (Using password:
YES)
the above eror results.
When I login the user without a password, it gets logged in
[rajagopal@ramak3 ~]$ mysql -u biowareuser
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 3.23.58
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
then i tried to load the database to which i have given full access for that
user:
mysql> use Warehouse
ERROR 1044: Access denied for user: '@localhost' to database 'Warehouse'
Then I tried to load the same database logging in as root so that i'll have
full access.
mysql> use Warehouse
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql>
The two thing that I dont understand are:
1) Why doesnt that user biowareuser login when i use the password option?
(but logs in without a password! I've created that user with a pasword
only.)
2) Why doesn't that database get loaded for the user 'biowareuser' though i
hav granted full previlege to him, using the grant command (the grant
command was successful. but still shows some access denied when trying to
load the database.)
--
With deviation from the convention, comes an invention.
---Rajagopal
Visit me at http://www.rajagopal.tk