Fix your mysql privileges
http://dev.mysql.com/doc/mysql/en/GRANT.html
DVP
----
Dathan Vance Pattishall http://www.friendster.com
> -----Original Message-----
> From: Hossain, Ashfaq (Ashfaq) [mailto:ashfaq@stripped]
> Sent: Wednesday, December 01, 2004 8:39 AM
> To: mysql@stripped
> Subject: MySQL Newbie: Running in UNIX
>
>
> 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: ashfaq@localhost
> 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'
>
>
>
>
