Author Topic: no information_schema database ?  (Read 13051 times)

westernx

  • Hero Member
  • *****
  • Posts: 55
no information_schema database ?
« on: September 29, 2010, 04:52:19 PM »
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

  • Administrator
  • *****
  • Posts: 493
Re: no information_schema database ?
« Reply #1 on: September 29, 2010, 06:10:22 PM »
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

  • Hero Member
  • *****
  • Posts: 55
Re: no information_schema database ?
« Reply #2 on: September 29, 2010, 06:28:16 PM »
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

  • Hero Member
  • *****
  • Posts: 55
Re: no information_schema database ?
« Reply #3 on: September 29, 2010, 09:28:41 PM »
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

  • Administrator
  • *****
  • Posts: 493
Re: no information_schema database ?
« Reply #4 on: September 29, 2010, 10:28:48 PM »
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
« Last Edit: September 29, 2010, 10:32:57 PM by jburk »