Hi Alan, you would have to do
mysql -u root -p <enter> 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 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 > > ================================================ -- ================================================ Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] 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]
