1) Server Helper Programs
- Service utilities , Launcher programs
mysqld
--Launch automatically by server helper programs
Launch manually to debug MySQL server configurations (error messages go to terminal by default)
Example:
$ mysqld --user=mysql --datadir=/var/lib/mysql --socket=/tmp/mysql.sock
1. mysqld_safe
Sets up error log and launches mysqld .Launch the mysqld_safe script, which in turn launches mysqld.
2. mysql.server
Used as wrapper around mysqld_safe for systems such as Linuc and Oracle Solaris that are using System V run-level directories.
3. mysqld_multi
Launches mysqld_safe multiple times
2) Installation Programs
- Perform part of initial installation configuration
1. mysql_secure_installation
Security program that enables initial secure configuration
2. mysql_tzinfo_to_sql
Utility that creates SQL script containing host's time zone information
3. mysql_upgrade
Ensure they are compatible with current version of MySQL
3) Utility Programs
- Perform functions without connecting to server
1. mysql_config_editor
- store login passwords, etc
Manages login paths to simplify how you connect command clients to MySQL server
- enables storing authentication credentials in encrypted file (mylogin.cnf --- user home directory)
To create a login path:
• To view a single login path in clear text:
mysql_config_editor set
--login-path=login-path --user=username
--password --host=hostname
• To view a single login path in clear text:
mysql_config_editor print
--login-path=login-path
• To view all login paths in clear text:
mysql_config_editor print --all
• To remove a login path:
mysql_config_editor print
--login-path=login-path
mysql_config_editor set --login-path=mysql --user=root --port=3306 --password
* Whenever you type mysql it will auto login
root@okprd5328:/seamnt/src101/mysql#mysql_config_editor print --login-path=mysql
[mysql]
user = root
password = *****
port = 3306
Just incase you forget the root password,
You can run this command.
[root@okprd1631 mysql]# my_print_defaults -s client
--user=root
--password=YourPasswordXXX
2. mysqlbinlog
Reads and replays the contents of binary log
3. mysqldumpslow
Reads and summarizes the contents of slow query log
4. mysql_ssl_rsa_setup
Create TLS keys and certificates
Client Programs
- Programs that connect to server
1. mysql
MySQL command line client
-- user, --password, --host, --socket
2. mysqladmin
Utility for monitoring, administering, and shutdown MySQL
- shutdown, password, variables
3. mysqldump
Backup utility
4. mysqlimport
Utility for importing contents
5. mysqlslap
Load emulation client
6. mysqlshow
Display database object metadata
7. mysqlcheck
Checking and Optimizing tables
--analyze , --check
Where to check all these programs ?
root@okprd5328:/usr/bin#ls *my*
myisamchk mysql mysqld_pre_systemd mysql_plugin mysql_ssl_rsa_setup
myisam_ftdump mysqladmin mysqldump mysqlpump mysql_tzinfo_to_sql
myisamlog mysqlbinlog mysqldumpslow mysql_secure_installation mysql_upgrade
myisampack mysqlcheck mysqlimport mysqlshow
my_print_defaults mysql_config_editor mysql_install_db mysqlslap