RE: How to configure mysql server?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Henry Hartley wrote:

> Assuming, as others have suggested, that you set the root password
> accidentally, you'll want to change it to something you know.  This
> isn't a big deal on a system you control.  Simply follow the
> instructions here:
> 
> http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

Thanks very much.

I followed the instructions, with one important difference -
I left the file mysql-init in /tmp -
and I can now connect as root!
-----------------------------------------------
[root@alfred ~]# service mysqld stop
Stopping MySQL:                                            [  OK  ]
[root@alfred ~]# cat /tmp/mysql-init
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('foo');

[root@alfred ~]# mysqld_safe --init-file=/tmp/mysql-init &
[1] 15993
WARNING: Found /var/lib/mysql/my.cnf
Datadir is deprecated place for my.cnf, please move it to /usr

[root@alfred ~]# Starting mysqld daemon with databases from /var/lib/mysql

[root@alfred ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.0.22

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> quit;
Bye
-----------------------------------------------

When I followed the instructions exactly, and ran
        mysqld_safe --init-file=~/mysql-init &
or
        mysqld_safe --init-file=./mysql-init &
I found the error

060623 12:05:09  InnoDB: Started; log sequence number 0 43655
060623 12:05:09 [ERROR] /usr/libexec/mysqld: File '~/mysql-init' not found
(Errcode: 2)
060623 12:05:09 [ERROR] Aborting

in /var/log/mysqld.log .

I presume that mysqld_safe is run by mysql in ~mysql ,
and so ~ and . are both taken to mean ~mysql .


-- 
Timothy Murphy  
e-mail (<80k only): tim /at/ birdsnest.maths.tcd.ie
tel: +353-86-2336090, +353-1-2842366
s-mail: School of Mathematics, Trinity College, Dublin 2, Ireland


[Index of Archives]     [Current Fedora Users]     [Fedora Desktop]     [Fedora SELinux]     [Yosemite News]     [Yosemite Photos]     [KDE Users]     [Fedora Tools]     [Fedora Docs]

  Powered by Linux