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:

1. [root@fileserver2 /]# rm -r /var/lib/mysql/
2. [root@fileserver2 /]# mysql_install_db
3. Installing all prepared tables
4. Fill help tables
5.  
6. To start mysqld at boot time you have to copy support-files/mysql.server
7. to the right place for your system
8.  
9. PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
10. To do so, start the server, then issue the following commands:
11. /usr/bin/mysqladmin -u root password 'new-password'
12. /usr/bin/mysqladmin -u root -h fileserver2 password 'new-password'
13. See the manual for more instructions.
14.  
15. You can start the MySQL daemon with:
16. cd /usr ; /usr/bin/mysqld_safe &
17.  
18. You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
19. cd sql-bench ; perl run-all-tests
20.  
21. Please report any problems with the /usr/bin/mysqlbug script!
22.  
23. The latest information about MySQL is available on the web at
24. http://www.mysql.com
25. Support MySQL by buying support/licenses at http://shop.mysql.com
26. [root@fileserver2 /]# cd /etc/init.d/
27. [root@fileserver2 init.d]# ./mysqld restart
28. Stopping MySQL:                                            [  OK  ]
29. Starting MySQL:                                            [  OK  ]
30. [root@fileserver2 init.d]# mysql
31. Welcome to the MySQL monitor.  Commands end with ; or \g.
32. Your MySQL connection id is 2 to server version: 5.0.22
33.  
34. Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
35.  
36. mysql>