Philip Mather wrote:
Mohsen,
First off, what version of MySQL are you running and on what platform?
Now when i use --skip-grant-tables i can see my databases.
Please help me...
When you use MySQL via a shell I would assume you're logging in as
root? You also say you can only see a "test" database, can you not see
a "mysql" database there as well? I would suggest that somehow either
the "mysql" database has been dropped/destroyed or perhaps just the
db, host, tables_priv, and user tables of that database have been
dropped/destroyed/messed up.
Log in via shell and show us the result of the following commands...
"
mysql> use mysql;
mysql> show tables;
mysql> SELECT COUNT(*) FROM db;
mysql> SELECT COUNT(*) FROM user;
"
If you can't see the database and/or the tables I'm talking about you
may want to just check your backups are working and come back to us.
Regards,
Phil
When i use "ps ax |grep mysql " i see following statements:
6173 ? S 0:00 /bin/sh /home/arman/mysql/bin/mysqld_safe
--basedir=/home/arman/mysql/ --datadir=/home/arman/mysql/var/
--socket=/tmp/arman.sock --port=3310 --user=root --skip-grant-tables
6220 ? S 1:21 /home/arman/mysql/libexec/mysqld
--basedir=/home/arman/mysql/ --datadir=/home/arman/mysql/var/
--user=root --pid-file=/home/arman/mysql/var//lnxsrv2.pid --skip-locking
--port=3310 --socket=/tmp/arman.sock --skip-grant-tables
Now when i use following command :
[EMAIL PROTECTED] root]# /home/arman/mysql/bin/mysql --port=3310
--socket=/tmp/arman.sock --user=root -p
& then input password i see following message:
Enter password:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
So,I can't use use command in mysql shell.
Yours,mohsen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
