1. How to set MySQL Root password?
# mysqladmin -u root password YOURNEWPASSWORD
2. How to Change MySQL Root password?
mysqladmin -u root -p123456 password 'xyz123'
3. How to check MySQL Server is running?
# mysqladmin -u root -p ping Enter password: mysqld is alive
4. How to Check which MySQL version I am running?
# mysqladmin -u root -p version Enter password: mysqladmin Ver 8.42 Distrib 5.5.28, for Linux on i686 Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Server version 5.5.28 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 7 days 14 min 45 sec
5. How to Find out current Status of MySQL server?
# mysqladmin -u root -ptmppassword status Enter password: Uptime: 606704 Threads: 2 Questions: 36003 Slow queries: 0
Opens: 15 Flush tables: 1 Open tables: 8 Queries per second avg: 0.059
6. How to check status of all MySQL Server Variable’s and value’s?
# mysqladmin -u root -p extended-status Enter password: +------------------------------------------+-------------+ | Variable_name | Value | +------------------------------------------+-------------+ | Aborted_clients | 3 | | Aborted_connects | 3 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 0 | | Binlog_stmt_cache_disk_use | 0 | | Binlog_stmt_cache_use | 0 | | Bytes_received | 6400357 | | Bytes_sent | 2610105 | | Com_admin_commands | 3 | | Com_assign_to_keycache | 0 | | Com_alter_db | 0 | | Com_alter_db_upgrade | 0 | | Com_alter_event | 0 | | Com_alter_function | 0 | | Com_alter_procedure | 0 | | Com_alter_server | 0 | | Com_alter_table | 0 | | Com_alter_tablespace | 0 | +------------------------------------------+-------------+
7. How to see all MySQL server Variables and Values?
To see all the running variables and values of MySQL server, use the command as follows.
# mysqladmin -u root -p variables Enter password: +---------------------------------------------------+------------------------------+ | Variable_name | Value | +---------------------------------------------------+------------------------------+ | auto_increment_increment | 1 | | auto_increment_offset | 1 | | autocommit | ON | | automatic_sp_privileges | ON | | back_log | 50 | | basedir | /usr | | big_tables | OFF | | binlog_cache_size | 32768 | | binlog_direct_non_transactional_updates | OFF | | binlog_format | STATEMENT | | binlog_stmt_cache_size | 32768 | | bulk_insert_buffer_size | 8388608 | | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | | collation_connection | latin1_swedish_ci | +---------------------------------------------------+------------------------------+
8. How to check all the running Process of MySQL server?
# mysqladmin -u root -p processlist Enter password: +-------+---------+-----------------+---------+---------+------+ | Id | User | Host | db | Command | Time | +-------+---------+-----------------+---------+---------+------+ | 18001 | rsyslog | localhost:38307 | rsyslog | Sleep | 5590 | | 18020 | root | localhost | | Query | 0 | +-------+---------+-----------------+---------+---------+------+
9. How to create a Database in MySQL server?
# mysqladmin -u root -p create mydatabasename Enter password:
# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 18027 Server version: 5.5.28 MySQL Community Server (GPL) by Remi Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mydatabasename | | mysql | | test | +--------------------+ 8 rows in set (0.01 sec) mysql>
10. How to drop a Database in MySQL server?
# mysqladmin -u root -p drop databasename Enter password: Dropping the database is potentially a very bad thing to do. Any data stored in the database will be destroyed. Do you really want to drop the 'databasename' database [y/N] y Database "databasename" dropped
No comments:
Post a Comment