FsseInfo: MySQL Administration

Revision [1172]

Last edited on 2011-09-23 10:12:43 by FsseInfo

Additions:

==MySql root password reset on CentOS/Oracle Linux/Red Hat==
==Stop MySql==
==Start MySql without any security or passwords==
==Change / Reset MySql root password==
==Restart MySql==

Deletions:

==MySql root password reset on CentOS/Oracle Unbreakable/Red Hat==
Stop MySql
Start MySql without security
Change / Reset MySql root password
Restart MySql

Revision [1171]

Edited on 2011-09-23 10:10:53 by FsseInfo

Additions:

# mysql -u root
mysql> USE mysql
Restart MySql
# service mysqld restart

Deletions:

# mysql -u root mysql
# mysqladmin shutdown
Start MySql normally
# service mysqld start

Revision [1170]

Edited on 2011-09-23 10:05:59 by FsseInfo

Additions:

# /usr/bin/mysqld_safe --skip-grant-tables &

Deletions:

~~# /usr/bin/safe_mysqld --skip-grant-tables &~~

Revision [459]

Edited on 2008-02-27 14:27:55 by FsseInfo

Additions:

==MySql root password reset on CentOS/Oracle Unbreakable/Red Hat==

Deletions:

~~==MySql root password reset on CentOS/Oracle/Red Hat==~~

Revision [458]

Edited on 2008-02-27 14:23:52 by FsseInfo

Additions:

>>http://dev.mysql.com/downloads/administrator/1.1.html
>>===MySQL Administration===
==MySql root password reset on Debian/Ubuntu==
To connect to MySQL as the root user do the following:
$ sudo mysql --defaults-extra-file=/etc/mysql/debian.cnf
==MySql root password reset on CentOS/Oracle/Red Hat==

Deletions:

====MySQL Administration====
http://dev.mysql.com/downloads/administrator/1.1.html
===MySql Root Password Reset===

Revision [33]

The oldest known version of this page was created on 2006-06-19 11:31:53 by FsseInfo