List:General Discussion« Previous MessageNext Message »
From:Dathan Vance Pattishall Date:December 1 2004 8:00pm
Subject:RE: MySQL Newbie: Running in UNIX
View as plain text  
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'
> 
> 
> 
> 


Thread
MySQL Newbie: Running in UNIXAshfaq \(Ashfaq\) Hossain1 Dec
  • RE: MySQL Newbie: Running in UNIXDathan Vance Pattishall1 Dec
  • Re: MySQL Newbie: Running in UNIXGleb Paharenko3 Dec
Re: MySQL Newbie: Running in UNIXAman Raheja1 Dec
Re: MySQL Newbie: Running in UNIXAman Raheja1 Dec