no information_schema database ?

[westernx]

Hello,

I just noticed that my MySQL on our os x server, running the qube supervisor, has no information_schema database.  Can I make one, and if so will it work with my current qube databases?  How would I make one?

thks,

R

[jburk]

Which version of Qube and MySQL are you running?

Which user are you logging into mysql as?  Most users, and the anonymous one, don't have SELECT privileges on the information_schema db.

Try: mysql -u root

[westernx]

OS X Server 10.5.8

qube! supervisor - version: 5.5-2

mysql  Ver 14.12 Distrib 5.0.82, for apple-darwin9.0 (i386) using  EditLine wrapper

Code: [Select]

vfx-xserve:~ root# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 20674
Server version: 4.1.22-standard

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases ;
+----------+
| Database |
+----------+
| 170qube  |
| 171qube  |
| 173qube  |
| 180qube  |
| 181qube  |
| 182qube  |
| 183qube  |
| 184qube  |
| 185qube  |
| 186qube  |
| 187qube  |
| 188qube  |
| 189qube  |
| 190qube  |
| 191qube  |
| mysql    |
| qube     |
| test     |
+----------+
18 rows in set (0.00 sec)


[westernx]

Code: [Select]

mysql> select table_schema, table_name from information_schema.tables where table_name like "21820%" ;
ERROR 1146 (42S02): Table 'information_schema.tables' doesn't exist


[jburk]

You're running a 4.1.22-standard version of MySQL Server; the INFORMATION_SCHEMA tables weren't added to MySQL until 5.0

Try "SELECT VERSION()"; it will return 4.0.22, the version of the server you're running, not the mysql client version.

If you upgrade your Qube supervisor to 6.0, you'll also get MySQL 5.0.45 installed as part of the supervisor installation.  Just be sure to stop the running Qube 5 supervisor and the 4.0.22 MySQL server before you install Qube 6.0