Re: changing mysqld deamon ownership.

-- From: "Kamara Eric R-M" <[EMAIL PROTECTED]> To: "2Hosts.com" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, May 30, 2003 1:15 AM Subject: Re: changing mysqld deamon ownership. > > Yeah...I don't think you need to make any changes.. > &g

Re: changing mysqld deamon ownership.

Hi Alan, you would have to do mysql -u root -p and then enter the password to connect. best regards Nils Valentin Tokyo/Japan 003年 5月 31日 土曜日 04:02、2Hosts.com さんは書きました: > 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

Re: changing mysqld deamon ownership.

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 t

Re: changing mysqld deamon ownership.

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 use

Re: changing mysqld deamon ownership.

Hi ???, O.K let's translate this. [admin admin]$ ps -u mysql > PID TTY TIME CMD > 11096 pts/000:00:00 mysqld > 11098 pts/000:00:00 mysqld > 11099 pts/000:00:00 mysqld > [admin admin]$ This shows you the proceses for the Linux user account "mysql". You can see this accou

Re: changing mysqld deamon ownership.

Yeah...I don't think you need to make any changes.. On Fri, 30 May 2003, 2Hosts.com wrote: > Thanks Kamara, > > So does that mean I don't need to change anything? > > > > > > [admin admin]$ ps auxw | grep mysqld > > > root 11073 0.0 0.1 1672 824 pts/0S01:12 0:00 sh > > > /usr/b

Re: changing mysqld deamon ownership.

Thanks Kamara, So does that mean I don't need to change anything? > > > [admin admin]$ ps auxw | grep mysqld > > root 11073 0.0 0.1 1672 824 pts/0S01:12 0:00 sh > > /usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var/lib/ > > > Presumably the "root" on line one shows i

Re: changing mysqld deamon ownership.

> [admin admin]$ ps auxw | grep mysqld > root 11073 0.0 0.1 1672 824 pts/0S01:12 0:00 sh > /usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var/lib/ > Presumably the "root" on line one shows it's running as root? this > paragraph in the book is extremely sketchy. What

Re: changing mysqld deamon ownership.

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/0S00:48 0:00 -bash admin13234

Re: changing mysqld deamon ownership.

gt;; <[EMAIL PROTECTED]> Sent: Friday, May 30, 2003 12:26 AM Subject: Re: changing mysqld deamon ownership. > 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 i

Re: changing mysqld deamon ownership.

> 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) > Sor

Re: changing mysqld deamon ownership.

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 SMay28 0:00 /sbin/mingetty