Hi ???, O.K let's translate this.
[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]$ This shows you the proceses for the Linux user account "mysql". You can see this account with cat /etc/passwd cat /etc/group The left side tells you that the script runs under the Linux User account "mysql". Don't mix this up with the mysql user accounts which your mysql cliens are using to connect to the mysqld (server) process. This means everything is alright. However... ---- If you want to use another Linux user account than you will have to create it, useradd xxxx passwd xxxx You will also need to chnage the user and usergrp. go to the database directory f.e. cd var/lib/mysql chown -R xxxx * chgrp -R xxxxgroup * I hope that should make it clearer. Best regards Nils Valentin Tokyo/Japan 2003年 5月 30日 金曜日 16:49、2Hosts.com さんは書きました: > 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 > > ================================================ -- ================================================ 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]