I would like to try out MySQL on my UNIX account (Solaris).
I DO NOT HAVE root privilieges in UNIX. I only have a normal user
privilege.
I have installed MySQL on my user UNIX account.
Looks like I get the Server going and can also get the status from the
Server.
But, I get an error msg when I try to create a database.
I have attached the unix screen dump below.
Any help will be greatly appreciated.
Thanks,
-Ashfaq Hossain
/ UNIX screen dump
/
Unix System
/
unix uname -a
SunOS 5.8 Generic_108528-24 sun4u sparc SUNW,Sun-Fire-880
/
Running MySQL Processes
/
unix ps -ef | grep mysql
ashfaq 22040 22015 0 11:13:23 pts/63 0:00
/home/ashfaq/MySQL/mysql-standard-4.1.7-sun-solaris2.9-sparc-64bit/bin/m
ysqld -
ashfaq 14026 9830 0 11:18:08 pts/63 0:00 grep mysql
ashfaq 22015 9830 0 11:13:23 pts/63 0:00 /bin/sh ./bin/mysqld_safe
/
Starting the Client
/
unix bin/mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 4.1.7-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
/
Checking Status
/
mysql status
--
bin/mysql Ver 14.7 Distrib 4.1.7, for sun-solaris2.9 (sparc)
Connection id: 7
Current database:
Current user: [EMAIL PROTECTED]
SSL:Not in use
Current pager: stdout
Using outfile: ''
Using delimiter:;
Server version: 4.1.7-standard
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset:latin1
Db characterset:latin1
Client characterset:latin1
Conn. characterset:latin1
UNIX socket:/tmp/mysql.sock
Uptime: 8 min 0 sec
Threads: 1 Questions: 24 Slow queries: 0 Opens: 12 Flush tables: 1
Open tables: 1 Queries per second avg: 0.050
/
/
/
Error Message : Please HELP!
/
/
/
mysql create database info ;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database
'info'