Christopher Juckins

SysAdmin Tips, Tricks and other Software Tools

User Tools

Site Tools


mysql_setup_options_for_a_new_install_config_on_rhel5

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
mysql_setup_options_for_a_new_install_config_on_rhel5 [2015/01/04 12:04] juckinsmysql_setup_options_for_a_new_install_config_on_rhel5 [2025/03/20 18:55] (current) – removed juckins
Line 1: Line 1:
-<code> 
-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 centos5x password 'new-password' 
- 
-Alternatively you can run: 
-/usr/bin/mysql_secure_installation 
- 
-which will also give you the option of removing the test 
-databases and anonymous user created by default.  This is 
-strongly recommended for production servers. 
- 
-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 mysql-test-run.pl 
-cd mysql-test ; perl mysql-test-run.pl 
- 
-Please report any problems with the /usr/bin/mysqlbug script! 
-</code> 
- 
-The latest information about MySQL is available on the web at 
-[[http://www.mysql.com]] 
- 
-How to reset the root password for mysql: 
- 
-[[http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html]] 
mysql_setup_options_for_a_new_install_config_on_rhel5.1420391089.txt.gz · Last modified: by juckins