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]