Re: MySQL Newbie: Running in UNIX

[Aman Raheja]

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]