Hi Nils, I tried what you said, here's what I got. Apologies in advance if I'm being a "slowbee" as well as a "newbie"/
[admin admin]$ ps -u USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND admin 9449 0.0 0.1 1700 936 pts/0 S 00:48 0:00 -bash admin 13234 0.0 0.1 2336 700 pts/0 R 01:49 0:00 ps -u [admin admin]$ ps -u mysql PID TTY TIME CMD 11096 pts/0 00:00:00 mysqld 11098 pts/0 00:00:00 mysqld 11099 pts/0 00:00:00 mysqld [admin admin]$ > Hi ???, > > I don't know which OS you are talking about, but I guess for a Linux OS. > > Try this: > > ps -u > > see on the left the Linux account it uses. > > ps -u > USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND > root 1266 0.0 0.0 1360 468 tty1 S May28 0:00 /sbin/mingetty > --noclear tty1 > root 1267 0.0 0.0 1360 468 tty2 S May28 0:00 /sbin/mingetty > tty2 > root 1268 0.0 0.0 1360 468 tty3 S May28 0:00 /sbin/mingetty > tty3 > root 1269 0.0 0.0 1360 468 tty4 S May28 0:00 /sbin/mingetty > tty4 > root 1270 0.0 0.0 1360 468 tty5 S May28 0:00 /sbin/mingetty > tty5 > root 1271 0.0 0.0 1360 468 tty6 S May28 0:00 /sbin/mingetty > tty6 > root 3676 0.0 0.3 5620 1664 pts/1 S 10:24 0:00 /bin/bash > root 3849 0.0 0.3 5616 1648 pts/2 S 11:12 0:00 /bin/bash > root 3943 0.0 0.3 2688 1652 pts/2 R 11:25 0:00 ps -u > > make sure there is NO mysql process here. > > Then do "ps -u mysql" - or whichever account it uses. > > baby-bumble-bee:~ # ps -u mysql > PID TTY TIME CMD > 750 ? 00:00:00 mysqld-max > 818 ? 00:00:00 mysqld-max > 819 ? 00:00:00 mysqld-max > 926 ? 00:00:00 mysqld-max > > > I assume you have an extra Linux user accout f.e "mysql" with no superuser > privileges. If not create one. > > In case it does not run as let's say "mysql" Linux user account you can > specify the user in /etc/my.cnf (or ~/.my.cnf or /var/lib/mysql/.my.cnf ) - > Please see the docs for more details. > > [mysqld] > user= mysql > > or > > [safe_mysqld] > user=mysql > > That should be it. > > Best regards > > Nils Valentin > Tokyo/Japan > > PS: The same question was asked within the last 24 hours. Look for threat > "database permissions" from Ted ;-) > > 2003年 5月 30日 金曜日 16:17、2Hosts.com さんは書きました: > > Hi guys, > > > > On page 54 of the Sams "teach yourself MySQL in 24 hrs" it says the owner > > should not be root, and to change it. I can't seem to find out how to do > > this - could anyone guide me in the right direction please? > > > > I searched the list archives to no avail. > > Many thanks. :o) > > -- > ================================================ > Valentin Nils > Internet Technology > > E-Mail: [EMAIL PROTECTED] > URL: http://www.knowd.co.jp/staff/nils > ------------------------------------------------ > 有限会社ナレッジデザイン > 〒182-0024 東京都調布市布田4-6-1 調布丸善ビル7F > Phone: 0424-40-7912 Fax: 0424-40-7913 > URL: http://www.knowd.co.jp > ================================================ > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]