Centos 配置系列之 mysql

来源：互联网发布：g76数控车床车蜗杆编程编辑：程序博客网时间：2024/06/05 09:36

一、安装 MySQL

首先来进行 MySQL 的安装。打开超级终端，输入：

<span class="sh_symbol">[</span>root@localhost <span class="sh_symbol">~]</span># yum install mysql mysql<span class="sh_symbol">-</span>server

安装完毕，让 MySQL 能够随系统自动启动：

<span class="sh_symbol">[</span>root@localhost <span class="sh_symbol">~]</span># chkconfig <span class="sh_symbol">--</span>levels <span class="sh_number">235</span> mysqld on<span class="sh_symbol">[</span>root@localhost <span class="sh_symbol">~]</span># <span class="sh_regexp">/etc/i</span>nit<span class="sh_symbol">.</span><span class="sh_normal">d</span><span class="sh_symbol">/</span>mysqld start

设置 MySQL 数据 root 账户的密码：

<span class="sh_symbol">[</span>root@localhost <span class="sh_symbol">~]</span># mysql_secure_installation

当出现如下提示时候直接按回车：

Enter current password <span class="sh_keyword">for</span> root

出现如下再次回车：

Set root password<span class="sh_symbol">?</span> <span class="sh_symbol">[</span><span class="sh_normal">Y</span><span class="sh_symbol">/</span>n<span class="sh_symbol">]</span>

出现如下提示输入你需要设置的密码，回车后在输入一次确认：

New password<span class="sh_symbol">:</span>

接下来还会有四个确认，分别是：

Remove anonymous users<span class="sh_symbol">?</span> <span class="sh_symbol">[</span><span class="sh_normal">Y</span><span class="sh_symbol">/</span>n<span class="sh_symbol">]</span>Disallow root login remotely<span class="sh_symbol">?</span> <span class="sh_symbol">[</span><span class="sh_normal">Y</span><span class="sh_symbol">/</span>n<span class="sh_symbol">]</span>Remove test database and access to it<span class="sh_symbol">?</span> <span class="sh_symbol">[</span><span class="sh_normal">Y</span><span class="sh_symbol">/</span>n<span class="sh_symbol">]</span>Reload privilege tables now<span class="sh_symbol">?</span> <span class="sh_symbol">[</span><span class="sh_normal">Y</span><span class="sh_symbol">/</span>n<span class="sh_symbol">]</span>

直接回车即可。

二、创建新用户

//登录MYSQL
@>mysql -u root -p
@>密码
//创建用户
mysql> insert into mysql.user(Host,User,Password) values("localhost","phplamp",password("1234"));
//刷新系统权限表
mysql>flush privileges;

这样就创建了一个名为：phplamp 密码为：1234 的用户。

三、授予权限
>grant all privileges on phplampDB.* to phplamp@localhost identified by '1234';
//刷新系统权限表
mysql>flush privileges;
mysql>其它操作

/*
如果想指定部分权限给一用户，可以这样来写:
mysql>grant select,update on phplampDB.* to phplamp@localhost identified by '1234';
//刷新系统权限表。
mysql>flush privileges;
*/

0 0