Re: changing mysqld deamon ownership.

gerald_clark Sat, 31 May 2003 05:46:22 -0700

It just means you didn't enter the password for root.

2Hosts.com wrote:

Hi Nils,
So if I su to root and try to start mysql, I get the following... does that
mean I'm secure?  I am still finding the very confusing, but doing my best
to look it up on dejanews and in books etc so as to not stress this group
too much.
[root admin]# mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)
[root admin]#
Kind regards,

Alan.
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]

Re: changing mysqld deamon ownership.

Reply via email to