Errors while executing mysql cmds in SUn solaris server Post: 302208833

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Errors while executing mysql cmds in SUn solaris server Post 302208833 by dbsurf on Wednesday 25th of June 2008 05:10:17 AM

06-25-2008

Registered User

Errors while executing mysql cmds in SUn solaris server

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?

dbsurf

View Public Profile for dbsurf

Find all posts by dbsurf

5 More Discussions You Might Find Interesting

1. Solaris

What's the difference: 'nuhup cmds' Vs 'cmds &'

Hello, Case: If I want to run a script background and logout, which command should I use ? 1)# ./script_name & 2)# nohup script_name 3)# nohup script_name & And any differences ? What happens if I redirect the output to a file? I learned somewhere that the (1) format will stop...

2. Shell Programming and Scripting

Errors while executing cmds in sun solaris

3. Solaris

Errors trying to compile PHP for use with MySQL on Solaris 10

have installed and am using the GNU based tools from the Sunfreeware site to compile PHP. I already have Apache, MySQL, and Oracle compiled and working properly. Below is my configure string for my PHP build: ./configure --prefix=/usr/local/php5 \...

4. Solaris

Compile PHP 5.3.6 with MySql on Sun Blade 1500 Solaris 10

Hello, I'm trying to compile PHP 5.3.6 with Apache2 and MySql 5.5.12. I hit a problem that I can't seem to resolve by myself and I could not find a solution on the web. It looks like Apache and MySql installed ok, I can start/stop them with no problem. When I try to compile PHP the...

5. Solaris

Sun Server and Solaris 7 Inquiry

Greetings! Will be firing up the good ole pizza box, soon. Does anyone know if Solaris 7 is still okay to use? Last time I attempted was 2006. Thank you in advance, ControlTomato

LEARN ABOUT DEBIAN

cvm-mysql

cvm-mysql(8)						      System Manager's Manual						      cvm-mysql(8)

NAME

       cvm-mysql - MySQL module

SYNOPSIS

       cvm-mysql

CREDENTIALS

       Pass phrase

DESCRIPTION

       This module queries a MySQL database for the account name, compares the stored pass phrase with the given one using crypt(3).

CONFIGURATION VARIABLES

       CVM_MYSQL_DEFAULT_FILE
	      The  full  path of the defaults file to read if the following variable is set.  If not set, the file $HOME/.my.cnf will be read (the
	      MySQL default).

       CVM_MYSQL_DEFAULT_GROUP
	      If set, the module will read connection default options from the named group in the defaults file as above

       CVM_MYSQL_HOST
	      The hostname or IP of the MySQL server.  If not set, a connection to the local host is assumed.

       CVM_MYSQL_USER
	      The MySQL login ID to connect as.  If not set, the invoking user is assumed.

       CVM_MYSQL_PASS
	      The password for the above user.

       CVM_MYSQL_DB
	      The database name, must be set.

       CVM_MYSQL_PORT
	      The port number for the TCP/IP connection (only used if the server is not local).

       CVM_MYSQL_POSTQ (optional)
	      The SQL query to execute after the credentials have been validated, see cvm-sql(7).

       CVM_MYSQL_PWCMP (optional)
	      The password comparison module to use.

       CVM_MYSQL_SOCKET
	      The path to the socket that should be used for connections to a local server.

       CVM_MYSQL_QUERY (optional)
	      The SQL query to issue to retrieve the row containing the account information from the database, see cvm-sql(7).

SEE ALSO

       cvm-sql(7), cvm-pgsql(8), cvm-pwfile(8), cvm-qmail(8), cvm-unix(8), cvm-vmailmgr(8),  cvm-benchclient(8),  cvm-checkpassword(8),  cvm-test-
       client(8)

	http://untroubled.org/pwcmp/pwcmp.html
	http://untroubled.org/cvm/cvm.html

																      cvm-mysql(8)