root@server [/var/lib/mysql]# ls -l /var/lib/mysql
total 20584
drwxr-x--x 8 mysql mysql 4096 Aug 10 11:37 ./
drwxr-xr-x 15 root root 4096 Aug 10 11:32 ../
drwx------ 2 mysql mysql 4096 Jul 27 14:21 eximstats/
drwx------ 2 mysql mysql 4096 Aug 7 11:59 horde/
-rw-rw---- 1 mysql mysql 10485760 Aug 10 11:15 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Aug 10 11:32 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Jul 27 13:54 ib_logfile1
drwxr-xr-x 2 root root 4096 Aug 10 08:05 mrki/
drwx--x--x 2 mysql mysql 4096 Aug 10 04:54 mysql/
srwxrwxrwx 1 mysql mysql 0 Aug 10 11:32 mysql.sock=
drwx------ 2 mysql mysql 4096 Aug 7 12:03 private_fund/
-rw-rw---- 1 mysql mysql 8242 Aug 10 11:32 server.private-fund.com.err
-rw-rw---- 1 mysql mysql 6 Aug 10 11:32 server.private-fund.com.pid
-rw-rw---- 1 mysql mysql 6523 Aug 9 14:56 sw4port8.gigeservers.com.err
-rw-rw---- 1 mysql mysql 6 Aug 9 14:11 sw4port8.pid
drwxr-xr-x 2 mysql mysql 4096 Aug 10 04:54 test/
a evo sta se desava kad se konektujem kao root korisnik:
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
+--------------------+
1 row in set (0.00 sec)
nigde nema onih nekoliko gornjih baza iz listinga???
a kad probam da kreiram novu bazu, isto kao root korisnik:
mysql> create database nova;
ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'nova'
O cemu se radi???