Mysql简介Mysql是瑞典MysqlAB公司开发的一种关系型数据库管理系统。目前是甲骨文的产品。特点Mysql使用的SQL语言是最常用的访问数据库的标准化语言。它是一个社区版本和一个商业版本。由于其体积小、速度快、总体拥有成本低，尤其是开源的特点，中小型网站的开发普遍选择Mysql作为网站数据库Mysql安装下载mysqlrepo源wgethttp://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm安装mysql-community-release-el7-5.noarch.rpm包sudorpm-ivhmysql-community-release-el7-5.noarch。rpm安装sudoyuminstallmysql-serverresetpasswordmysql-uroot可能会报这样的错误：ERROR2002(HY000):Can'tconnecttolocalMySQLserverthroughsocket'/var/lib/mysql/mysql.sock'(2)，原因是/var/lib/mysql的访问权限问题。以下命令将/var/lib/mysql的所有者更改为当前用户：sudochown-Rroot:root/var/lib/mysqlservicemysqldrestartmysql-uroot#mysqlcommandusemysql;UPDATEuserSETpassword=password('新密码')WHEREuser='root';刷新权限；出口;开发端口3306sudovim/etc/sysconfig/iptables#add-AINPUT-ptcp-mstate--stateNEW-mtcp--dport3306-jACCEPT#Restartsudoserviceiptablesrestartcharactersetconfigurationvim/etc/my.cnf#在[mysqld]节点下添加default-character-set=utf8character-set-server=utf8#:wq保存退出自启动配置chkconfigmysqldonstartservicemysqldstartdatabaseinitializationoperation#deleteanonymoususerdeletefrommysql.userwhereuser='';#设置用户权限和密码，远程连接权限GRANTallprivilegesON*.*TO'scott'@'%'IDENTIFIEDBY'12345678'WITHGRANTOPTION;#Createdatabasecreatedatabase`book`defaultcharactersetutf8collat??eutf8_general_ci;#设置数据库权限grantallprivilegesonbook.*tobook@'%'identifiedby'book'withgrantoption;flushprivileges;#Restartthedatabaseservicemysqldrestart
