Free Software Server Environment : MySqlAdmin

HomePage :: Categories :: PageIndex :: RecentChanges


Search this site: FSSE.INFO is produced by "osde8info" :

Revision [459]

Most recent edit made 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:

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 edited on 2006-06-19 11:31:53 by FsseInfo

MySQL Administration

http://dev.mysql.com/downloads/administrator/1.1.html

MySql Root Password Reset

Stop MySql
# service mysqld stop


Start MySql without security
# /usr/bin/safe_mysqld --skip-grant-tables &


Change / Reset MySql root password
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('new_password') WHERE user='root'
mysql> FLUSH PRIVILEGES; 
mysql> exit;


Stop MySql
# mysqladmin shutdown


Start MySql normally
# service mysqld start



REFERRERS
MySqlAdministration
MySqlDesignQuery
Valid XHTML 1.0 Transitional :: Valid CSS :: Powered by WikkaWiki
Page was generated in 0.0276 seconds