安装mysql 服务器端 :
# yum install mysql-server
安装完成后启动mysql服务:
service mysqld start
给mysql创建一个root管理员:
# mysqladmin -u root password 123456
用刚创建的帐号连接mysql:
# mysql -u root -p
输入密码即可。。。
1. 配置开机启动服务
/sbin/chkconfig httpd on [设置apache服务器httpd服务开机启动] /sbin/chkconfig –add mysqld [在服务清单中添加mysql服务] /sbin/chkconfig mysqld on [设置mysql服务开机启动] /sbin/service httpd start [启动httpd服务,与开机启动无关] /sbin/service mysqld start [启动mysql服务,与开机无关]
2. 设置mysql数据库root帐号密码。默认的初始化密码为空~~~
mysqladmin -u root password ‘new-password’ [引号内填密码]
3. 让mysql数据库更安全
mysql -u root -p mysql> DROP DATABASE test; [删除test数据库] mysql> DELETE FROM mysql.user WHERE user = ”; [删除匿名帐户] mysql> FLUSH PRIVILEGES; [重载权限]
4.安装上mysql扩展
yum -y install mysql-connector-odbc mysql-devel libdbi-dbd-mysql
5.设置默认编码等一些初始参数(my.cnf)
vi /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql default-character-set=utf8 [添加] default-storage-engine=INNODB [添加] old_passwords=1 [client] default-character-set=utf8 [添加] [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
2,允许通过网络访问mysql
grant all privileges on *.* to root @"%" identified by "123456"; flush privileges; //刷新刚才的内容
语句的格式为:
grant 权限 on 数据库名.表名 to 用户@登录主机 identified by "用户密码";
@后面是访问MySQL的客户端IP地址(或是主机名);% 代表任意的客户端,如果填写 localhost为本地访问(那此用户就不能远程访问该MySQL数据库了)