Sunday, September 02, 2007

MySQL "Ignoring query to other database"

"Ignoring query to other database"

[root@localhost]# mysql -v -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 4.1.20

Reading history-file /root/.mysql_history
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
--------------
show databases
--------------

+----------+
| Database |
+----------+
| mysql |
| test |
+----------+

1 comment:

Unknown said...

In the command line make sure you used the correct syntax when connecting to Mysql host

Correct example:
# mysql -uroot -ppassword

Wrong example: (You facing error because using wrong syntax)
# mysql -rroot -ppassword

Thank you,

Subramani

website: www.webserverexpert.net