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:[EMAIL PROTECTED] > Sent: Wednesday, December 01, 2004 8:39 AM > To: [EMAIL PROTECTED] > 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: [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' > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
