Home  >  Article  >  Database  >  CentOS6 安装 MySQL 并配置_MySQL

CentOS6 安装 MySQL 并配置_MySQL

WBOY
WBOYOriginal
2016-06-01 13:11:261683browse

CentOS6CentOS

CentOS6 修改 MySQL 配置

查看系统是否安装了MySQL -->使用命令:

rpm -qa | grep mysql 

卸载已安装的MySQL-->使用命令:

#rpm -e --nodeps  mysql-libs-5.1.61-4.el6.x86_64要将 /var/lib/mysql文件夹下的所有文件都删除干净

MySQ安装

1.    执行命令:安装mysql-server

yum -y install mysql-server
2.    安装完成后执行初始化命令
service mysqld start  或  /etc/init.d/mysqld start
3.    修改mysql的配置文件(修改默认编码)

    复制my-large.cnf文件到/etc/my.cnf --> 执行命令:

cp /usr/share/doc/mysql-server-4.1.12/my-large.cnf  /etc/my.cnf如果提示是否覆盖,Y 即可;

   打开my.cnf修改编码 --> 执行命令:

vim /etc/my.cnf在[mysqld]下添加:default-character-set=utf8修改指定的默认的引擎:default-storage-engine=INNODB是否区分大小写:  lower_case_table_names=1  0:区分大小写 1:不区分大小写<p>在[client]下添加:default-character-set=utf8</p>
4.    重启MySQL服务 --> 执行命令:
service mysqld restart   或 /etc/init.d/mysqld restart
5.    登陆mysql --> 执行命令:
mysql  或 mysql -uroot -p查看 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/share/mysql/charsets/ |+--------------------------+----------------------------+修改成功;

为连接MySQL的主机分配权限(方便远程连接MySQL数据库):

mysql> GRANT ALL ON *.* TO 'username'@'%' identified by 'password' WITH GRANT OPTION; //%可以是你的IP 注意:修改在防火墙 开启 3306 端口;在本人博客:http://my.oschina.net/haopeng/blog/268523

安装完成之后为MySQL设置root密码--> 使用命令:

/usr/bin/mysqladmin -u root password '123456'

修改mysql root 密码

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');

mysql安装目录说明

/var/lib/mysql           数据库文件/usr/share/mysql         命令及配置文件/usr/bin                 (mysqladmin、mysqldump等命令)



 



Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn