MySQL 安装配置

57 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).OK...5、创建开机启动脚本$ cd /usr/local/webserver/mysql/$ cp support-files/mysql.server /etc/rc.d/init.d/mysqld $ chkconfig --add mysqld $ chkconfig --level 35 mysqld on6、启动mysql服务器$ service mysqld start7、连接 MySQL$ /usr/local/webserver/mysql/bin/mysql -u root -p修改MySQL用户密码mysqladmin -u用户名 -p旧密码 password 新密码或进入mysql命令行SET PASSWORD FOR '用户名'@'主机' = PASSWORD(‘密码');创建新用户并授权:





grant all privileges on *.* to 用户名@'%' identified by '密码' with grant option;其他命令启动：service mysqld start停止：service mysqld stop重启：service mysqld?restart重载配置：service mysqld?reload