--
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
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
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
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
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
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
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
> [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
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
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
> 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
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
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)
--
MySQL General
On Sat, 18 Aug 2001, Philippe Paravicini wrote:
> could you not add the 'animel' user to the 'mysql' group?
>
> > I have done "chgrp animel *" on the directory that contains the files of
> > the database "animelyrics", but new tables that I create are group "mysql"
> > instead of group "animel".
could you not add the 'animel' user to the 'mysql' group?
-Original Message-
From: Philip Mak [mailto:[EMAIL PROTECTED]]On Behalf Of
Philip Mak
Sent: Saturday, August 18, 2001 7:10 PM
To: MySQL Mailing List
Subject: Database File group ownership
I have a database
I have a database called "animelyrics". I want to make it so that the
files inside this database are readable to the UNIX user "animel", so that
I can do backups easier.
I have done "chgrp animel *" on the directory that contains the files of
the database "animelyrics", but new tables that I crea
> The tables are fine when opened on linux. Is there something called as
changing of ownership of tables in NT. I have used the standard binary
version for windows.
I haven't used the NT version but wouldn't the normal GRANT and REVOKE
statements fill your needs?
> 3.23.37.
&g
At 11:18 AM + 5/10/01, Prachi Nadgouda wrote:
>The tables are fine when opened on linux. Is there something called
>as changing of ownership of tables in NT. I have used the standard
>binary version for windows.
I'm guessing from the preceding command and your original mess
The tables are fine when opened on linux. Is there something called as changing of
ownership of tables in NT. I have used the standard binary version for windows.
3.23.37.
Is it possible that some of the files can be corrupt? When I write the query as
select count(*) from table_name I get
Dear Y'all -
Paul DuBois writes:
> At 9:53 AM -0400 5/9/01, Brian Cuttler wrote:
> >
> >The developers that want to use the database would like ownership
> >of the files and daemon so that they can modify and restart at will.
>
> Tell them to pick one
At 9:53 AM -0400 5/9/01, Brian Cuttler wrote:
>Hello,
>
>We are installing MySQL 3.22.21 as pre-built for IRIX, installing
>on IRIX 6.5.7m.
>
>The developers that want to use the database would like ownership
>of the files and daemon so that they can modify and restart at wil
Hello,
We are installing MySQL 3.22.21 as pre-built for IRIX, installing
on IRIX 6.5.7m.
The developers that want to use the database would like ownership
of the files and daemon so that they can modify and restart at will.
I need to know if its safe to open access and if so, which files
Ok, this is confusing me. Under FreeBSD 4.2 and MySQL 3.23.36-debug:
The mysqld process is not running as root, but as 'mysqld:mysqld'.
bmdb2# ps -orgid,ruid,command -eww -p 46884
RGID RUID COMMAND
6724 6724 MYSQL_TCP_PORT=3306 OLDPWD=/var/mysqld/db/mojo
log_dir=/var/mysqld/log TMPD
ysql" program directory owned by "root.root" (user and
group = "root"), as long as the "var" subdirectory and all the files and
directories in "var" are owned by "mysql.mysql" with 2770 (rwxrws---) for
the directory permissions and 660 (rw-rw
-Ursprungliche Nachricht-
Von: Foresight Systems Ltd. [mailto:[EMAIL PROTECTED]]
Gesendet am: Mittwoch, 4. April 2001 10:57
An: Brian Warn;
Betreff: Mysqld problem Re: ownership/permission problems
Dear Sir,
Since you already have mysql running, we seek your help in sorting out
some
cussion in Monty's book on p. 417 about this.
>
> Thanks,
> Brian
>
> - Original Message -
> From: "B. van Ouwerkerk" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, April 03, 2001 11:20 AM
> Subject: Re: ownership/permission
I finally did find a discussion in Monty's book on p. 417 about this.
Thanks,
Brian
- Original Message -
From: "B. van Ouwerkerk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 03, 2001 11:20 AM
Subject: Re: ownership/permission proble
>I haven't had any success so far finding any help in the manual or Monty's
>book about this particular condition, so any help is appreciated.
I don't know about the RPM's. But if you would install from source there is
a directory called Docs containing a manual.txt I did NOT compare this with
After installing the server and client RPMs on my RH 7 box and verifying that
everything worked properly as root. Since I want mysql to run as the mysql user, I
searched for every directory where mysql occurred and changed ownership from root:root
to mysql:root. I can start safe_mysqld fine
At 5:56 PM -0800 3/30/01, Guo, Zhian wrote:
>Hi,
>We have been encountering a problem running mysql on sgi. We normally run
>it as a normal user, which writes the file /tmp/mysql.sock. However, when
>the machine is rebooted while the daemon is running, the mysql.sock file'
Hi,
We have been encountering a problem running mysql on sgi. We normally run
it as a normal user, which writes the file /tmp/mysql.sock. However, when
the machine is rebooted while the daemon is running, the mysql.sock file's
ownership will change to root. After that we can no longer
31 matches
Mail list logo
