Pardon my posting as soon as I subscribed to this list, but I have
a problem that's really annoying me. I just installed MySQL on
a virtual server account that I have, and for some reason, mysql refuses
to list my databases or tables, although they seem to be there. I've
included a log below, which may be somewhat lengthy, but hopefully
should explain what I'm seeing.
Does anyone have any ideas what could be happening here?
$ mysql -u root '-pMyPassword'
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11 to server version: 3.23.51-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+----------+
| Database |
+----------+
| |
| |
| |
| |
| |
| |
| |
+----------+
7 rows in set (0.00 sec)
mysql> use mysql;
Database changed
mysql> show tables;
Empty set (0.00 sec)
mysql> describe user;
+-----------------+-----------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-----------------+------+-----+---------+-------+
| Host | char(60) binary | | PRI | | |
| User | char(16) binary | | PRI | | |
| Password | char(16) binary | | | | |
| Select_priv | enum('N','Y') | | | N | |
| Insert_priv | enum('N','Y') | | | N | |
| Update_priv | enum('N','Y') | | | N | |
| Delete_priv | enum('N','Y') | | | N | |
| Create_priv | enum('N','Y') | | | N | |
| Drop_priv | enum('N','Y') | | | N | |
| Reload_priv | enum('N','Y') | | | N | |
| Shutdown_priv | enum('N','Y') | | | N | |
| Process_priv | enum('N','Y') | | | N | |
| File_priv | enum('N','Y') | | | N | |
| Grant_priv | enum('N','Y') | | | N | |
| References_priv | enum('N','Y') | | | N | |
| Index_priv | enum('N','Y') | | | N | |
| Alter_priv | enum('N','Y') | | | N | |
+-----------------+-----------------+------+-----+---------+-------+
17 rows in set (0.00 sec)
mysql> select * from user where user = 'root';
+-----------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| Host | User | Password | Select_priv | Insert_priv | Update_priv |
|Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv |
|File_priv | Grant_priv | References_priv | Index_priv | Alter_priv |
+-----------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| localhost | root | 33eca9836fc5219c | Y | Y | Y | Y
| | Y | Y | Y | Y | Y | Y
| | Y | Y | Y | Y |
| server38 | root | | Y | Y | Y | Y
| | Y | Y | Y | Y | Y | Y
| | Y | Y | Y | Y |
+-----------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
2 rows in set (0.08 sec)
mysql> quit
--
Bob Bell <[EMAIL PROTECTED]>
-------------------------------------------------------------------------
"MSN [the Microsoft Network] has a guy whose full time job is
walking around rebooting NT Servers as they crash."
-- Alex St. John, former Microsoft employee
---------------------------------------------------------------------
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
