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]
