MySQL reset

MySQL reset

offline
  • gamzzy 
  • Legendarni građanin
  • Pridružio: 24 Apr 2003
  • Poruke: 10725
  • Gde živiš: Novi Sad

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>



Registruj se da bi učestvovao u diskusiji. Registrovanim korisnicima se NE prikazuju reklame unutar poruka.
Ko je trenutno na forumu
 

Ukupno su 1020 korisnika na forumu :: 43 registrovanih, 8 sakrivenih i 969 gosta   ::   [ Administrator ] [ Supermoderator ] [ Moderator ] :: Detaljnije

Najviše korisnika na forumu ikad bilo je 3466 - dana 01 Jun 2021 17:07

Korisnici koji su trenutno na forumu:
Korisnici trenutno na forumu: 357magnum, ajo baba, Apok, arsa, Brana01, celik, CikaKURE, dankisha, DPera, drimer, havoc995, ikan, ivan1973, ivica976, janbo, Još malo pa deda, Karla, kolle.the.kid, ljuba, mercedesamg, mikrimaus, milenko crazy north, Milometer, Milos ZA, moldway, mrvica78, Nikolaa11, PAGZLY, Romibrat, royst33, sap, ser.hill, slonic_tonic, Srle993, Stanlio, Stoilkovic, Toper, Trpe Grozni, tubular, VJ, VP6919, vukovi, zixmix