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