mysql for linux5.4_Linux平台下MySQL 5.5的编译安装【RHEL5.4】

[root@ www.linuxidc.com mysql-5.5.25]# /usr/local/mysql5.5.25/bin/mysql

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 1

Server version: 5.5.25-log Source distribution

Copyright (c) 2000, 2011, 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.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>select user,password,host from mysql.user;

+------+----------+---------------+

| user | password | host          |

+------+----------+---------------+

| root |          | localhost     |

| root |          | dg53.yang.com |

| root |          | 127.0.0.1     |

| root |          | ::1           |

|      |          | localhost     |

|      |          | dg53.yang.com |

+------+----------+---------------+

6 rows in set (0.00 sec)

mysql>show plugins;

+-----------------------+--------+--------------------+---------+---------+

| Name                  | Status | Type               | Library | License |

+-----------------------+--------+--------------------+---------+---------+

| binlog                | ACTIVE | STORAGE ENGINE     | NULL    | GPL     |

| mysql_native_password | ACTIVE | AUTHENTICATION     | NULL    | GPL     |

| mysql_old_password    | ACTIVE | AUTHENTICATION     | NULL    | GPL     |

| CSV                   | ACTIVE | STORAGE ENGINE     | NULL    | GPL     |

| MEMORY                | ACTIVE | STORAGE ENGINE     | NULL    | GPL     |

| MyISAM                | ACTIVE | STORAGE ENGINE     | NULL    | GPL     |

| MRG_MYISAM            | ACTIVE | STORAGE ENGINE     | NULL    | GPL     |

| PERFORMANCE_SCHEMA    | ACTIVE | STORAGE ENGINE     | NULL    | GPL     |

| InnoDB                | ACTIVE | STORAGE ENGINE     | NULL    | GPL     |

| INNODB_TRX            | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_LOCKS          | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_LOCK_WAITS     | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_CMP            | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_CMP_RESET      | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_CMPMEM         | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_CMPMEM_RESET   | ACTIVE | INFORMATION SCHEMA | NULL    | GPL     |

| partition             | ACTIVE | STORAGE ENGINE     | NULL    | GPL     |

+-----------------------+--------+--------------------+---------+---------+

17 rows in set (0.00 sec)

mysql>show variables like '%default%';

+------------------------+--------+

| Variable_name          | Value  |

+------------------------+--------+

| default_storage_engine | InnoDB |

| default_week_format    | 0      |

+------------------------+--------+

2 rows in set (0.00 sec)

mysql>show variables like '%character%';

+--------------------------+----------------------------------------+

| Variable_name            | Value                                  |

+--------------------------+----------------------------------------+

| character_set_client     | utf8                                   |

| character_set_connection | utf8                                   |

| character_set_database   | utf8                                   |

| character_set_filesystem | binary                                 |

| character_set_results    | utf8                                   |

| character_set_server     | utf8                                   |

| character_set_system     | utf8                                   |

| character_sets_dir       | /usr/local/mysql5.5.25/share/charsets/ |

+--------------------------+----------------------------------------+

8 rows in set (0.00 sec)