Errors while executing mysql cmds in SUn solaris server

UNIX for Beginners Q & A UNIX for Dummies Questions & Answers
1

Hi All,

I am using mysql at sun solaris unix(Hp) server. I logged into mysql server with root as user. its logged in properly. Then i used 'show databases' mysql command. its display all the available databases.

for example
mysql > show databases;
It displayed as follows.

exampledb1
exampledb2
mysql
test

Now i used mysql > use exampledb1;
its given message called database changed.

now i trying to show all the tables under exampledb1 database using the below command.

mysql > show tables;

Now i am getting one error called

ERROR 12: Can't read dir of './exampledb1/' (Errcode: 13)

then i tried to drop the exampledb1 database using the below command.

mysql> drop database exampledb1;

Now i am getting different error.

ERROR 1008: Can't drop database 'exampledb1'. Database doesn't exist

can you please give me solutions for the above errors?

2

Hi,

Thing is, you're logged in a ROOT. I'm not 100% sure about this but my guess is that you should try login as the DB user instead?.