Re: MySQL Newbie: Running in UNIX
Hello. Try to connect as root (use -u root) or another user which has privilege to create new databases. >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' > > Thread"Hossain, Ashfaq (Ashfaq)" <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Newbie: Running in UNIX
This did not mean that's how you should work. I had this suggestion to confirm my doubt that something in the user table of mysql is messed up This was to allow you to setup a password for root or maybe another user (who can create) and then switch back to normal mysqld startup, to enable grant privs. Thanks Aman Raheja Hossain, Ashfaq (Ashfaq) wrote: Restart mysqld with the --skip-grant-tables option . Thanks. This suggestion works. Does it also mean I am skipping the grant-tables? -Original Message- From: Aman Raheja [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 01, 2004 12:57 PM To: Hossain, Ashfaq (Ashfaq) Subject: Re: MySQL Newbie: Running in UNIX log in as root > mysql -uroot then you are the boss Aman Raheja Hossain, Ashfaq (Ashfaq) wrote: 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]
RE: MySQL Newbie: Running in UNIX
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]
Re: MySQL Newbie: Running in UNIX
Restart mysqld with the --skip-grant-tables option and then try Aman Raheja Hossain, Ashfaq (Ashfaq) wrote: Thanks. But, it confuses the unix "root" with the mysql root. I don't have the unix root previleges. Am I doing something wrong? Here is the error: unix> bin/mysql -uroot ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]