MySQL reset

• 0Niko još nije pohvalio poruku.
  Registruj se da bi pohvalio/la poruku!

Kako da pobrisem sva podesavanja mysql-a i krenem iz pocetka
U pitanju je Linux i MySQL 5.0

Prvenstveno mi je bitno da uklonim root password. Ostalo mi je manje vise nebitno, sve baze su backup-ovane, u startu nije bilo password-a, samo me nista ne pitajte osim ako ne shvatate sta mi treba.

Dopuna: 16 Avg 2006 19:40

Resio sam:
[root@fileserver2 /]# rm -r /var/lib/mysql/ [root@fileserver2 /]# mysql_install_db Installing all prepared tables Fill help tables To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h fileserver2 password 'new-password' See the manual for more instructions. You can start the MySQL daemon with: cd /usr ; /usr/bin/mysqld_safe & You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; perl run-all-tests Please report any problems with the /usr/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at http://shop.mysql.com [root@fileserver2 /]# cd /etc/init.d/ [root@fileserver2 init.d]# ./mysqld restart Stopping MySQL:                                            [  OK  ] Starting MySQL:                                            [  OK  ] [root@fileserver2 init.d]# mysql 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>