[Techtalk] MYSQL - newbie questions.

Betty Johnson bettyj at telusplanet.net
Mon May 20 08:14:07 EST 2002


I am trying to learn to use MySQL.  I am running Mandrake 8.1 and MySQL 
version 3.23.41. I am following along in a book and it tells me I should not 
be running the mysqld as root.  When I run the command ps auxw | grep mysqld 
I get the following output.  

root      2106  0.0  0.3  2444 1240 ?        S    07:45   0:00 /bin/sh 
/usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var
mysql     2143  0.0  1.2 27024 4560 ?        S    07:45   0:00 
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
mysql     2146  0.0  1.2 27024 4560 ?        S    07:45   0:00 
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
mysql     2147  0.0  1.2 27024 4560 ?        S    07:45   0:00 
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
mysql     2148  0.0  1.2 27024 4560 ?        S    07:45   0:00 
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --
root      2994  0.0  0.1  1760  620 pts/1    S    08:06   0:00 grep mysqld

This looks like I am running the process as root but being fairly new at all 
this, I am just not sure. If I am, how can I change it? Also when I try to 
add a database as my user, it will not let me do it. Can I change this by 
just adding mysql permissions to my user ID?

Sorry for the newbie type questions and thanks.
-



More information about the Techtalk mailing list