[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