|
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>
|
