Mysql应用linux下mysql数据库安装与配置步骤

发布时间：2020-12-12 02:39:16 所属栏目：MySql教程来源：网络整理

导读：《Mysql应用linux下mysql数据库安装与配置步骤》要点：本文介绍了Mysql应用linux下mysql数据库安装与配置步骤，希望对您有用。如果有疑问，可以联系我们。导读：一,首先,查看LINUX的版本[root@jbxue mysql]# lsb_release -aLSB Version: :core-3.1-amd64:c

《Mysql应用linux下mysql数据库安装与配置步骤》要点：
本文介绍了Mysql应用linux下mysql数据库安装与配置步骤，希望对您有用。如果有疑问，可以联系我们。

导读：一,首先,查看LINUX的版本 [root@jbxue mysql]# lsb_release -aLSB Version: :core-3.1-amd64:core-3.1-ia32:core-3.1-noarch:graphic...

MYSQL必读一,查看LINUX的版本
?

[root@jbxue mysql]# lsb_release -a
LSB Version: :core-3.1-amd64:core-3.1-ia32:core-3.1-noarch:graphics-3.1-amd64:graphics-3.1-ia32:graphics-3.1-noarch Distributor ID: RedHatEnterpriseServer Description: Red Hat Enterprise Linux Server release 5.2 (Tikanga) Release: 5.2 Codename: Tikanga
?

MYSQL必读然后,去mysql官网http://dev.mysql.com/downloads/mysql/下载MySQL的相应版本的安装文件.
一般情况下,下载两个和linux系统相对应的mysql安装文件即可.

MYSQL必读分别是server和client版本.
?

http://downloads.mysql.com/archives.php?p=mysql-5.1&v=5.1.58
RedHat Enterprise Linux 5 RPM (AMD64,Client programs) (4 Jul 2011,7.2M)
RedHat Enterprise Linux 5 RPM (AMD64,Server) (4 Jul 2011,20.3M)
?

MYSQL必读具体文件见二.
?
二,将下载后的对应的安装文件放到linux下自定义的一个新建的文件夹mysql下.
使用命令安装相应的rpm文件.

MYSQL必读在mysql文件路径下,输入如下命令即可.

MYSQL必读首先,安装服务器端：
?

[root@jbxue mysql]#rpm -ivh MySQL-server-community-5.1.58-1.rhel5.x86_64.rpm

MYSQL必读其次,安装客户端：
?

[root@jbxue mysql]#rpm -ivh MySQL-client-community-5.1.58-1.rhel5.x86_64.rpm
?

MYSQL必读例如：
?

[root@jbxue software]# rpm -ivh MySQL-server-community-5.1.58-1.rhel5.x86_64.rpm?
Preparing...??????????????? ########################################### [100%]?
?? 1:MySQL-server-community ########################################### [100%]?
?
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !?
To do so,start the server,then issue the following commands:?
?
/usr/bin/mysqladmin -u root password 'new-password'?
/usr/bin/mysqladmin -u root -h? password 'new-password'?
?
Alternatively you can run:?
/usr/bin/mysql_secure_installation?
?
which will also give you the option of removing the test?
databases and anonymous user created by default.? This is?
strongly recommended for production servers.?
?
See the manual for more instructions.?
?
Please report any problems with the /usr/bin/mysqlbug script!?
?
Starting MySQL..[è·?¨]?
Giving mysqld 2 seconds to start?
[root@jbxue software]# rpm -ivh MySQL-client-community-5.1.58-1.rhel5.x86_64.rpm?
Preparing...??????????????? ########################################### [100%]?
?? 1:MySQL-client-community ########################################### [100%]?
[root@jbxue software]#?
?

MYSQL必读三,安装完成后,
mysql安装目录可能在：/usr/bin/mysql?
mysql启动文件可能在: /etc/rc.d/init.d/mysqld
使用whereis mysql命令来查找它安装的路径
使用命令 rpm -qal | grep mysql 确定linux下已安装MYSQL的安装路径.
例如：
?

[root@jbxue mysql]# rpm -qal | grep mysql
?
//使用如下命令查看系统是否已经安装mysql
[root@jbxue mysql]# rpm –qa | grep mysql
?

MYSQL必读或键入命令：
?

[root@jbxue mysql]$ netstat -nat
tcp 0 0 127.0.0.1:3306 127.0.0.1:33648 ESTABLISHED tcp 0 0 127.0.0.1:3306 127.0.0.1:33649 ESTABLISHED
?

MYSQL必读出现以上内容.
或直接敲入命令mysql+回车
?

[root@jbxue ~]$mysql Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 5136 Server version: 5.1.58-community MySQL Community Server (GPL) Copyright (c) 2000,2010,Oracle and/or its affiliates. All rights reserved. This software comes with ABSOLUTELY NO WARRANTY. This is free software,and you are welcome to modify and redistribute it under the GPL v2 license Type 'help;' or 'h' for help. Type 'c' to clear the current input statement. mysql>
?

MYSQL必读即表示linux下mysql安装成功

MYSQL必读第二部发,对已安装完成的mysql,进行相应的配置

MySQL默认没有暗码,安装完毕增加暗码的重要性是不言而喻的.
1、命令
usr/bin/mysqladmin -u root password 'new-password'
格式：mysqladmin -u用户名 -p旧暗码 password 新暗码
例：给root加个暗码ysong.
键入以下命令：
[root@jbxue ~]$ /usr/bin/mysqladmin -u root password ysong
注：因为开始时root没有暗码,所以-p旧暗码一项就可以省略了.
?
此时,在敲入,即可访问mysql
?

[root@jbxue ~]$ mysql -uroot -pysong
?
[ysong@IDC ~]$mysql -uroot -pysong Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 5159 Server version: 5.1.58-community MySQL Community Server (GPL) Copyright (c) 2000,and you are welcome to modify and redistribute it under the GPL v2 license Type 'help;' or 'h' for help. Type 'c' to clear the current input statement. mysql>
?

MYSQL必读1、用命令启动mysql
MySQL安装完成后启动文件mysql在/etc/init.d目录下,在需要启动时运行下面命令即可.
[root@jbxue ~]$sudo? /etc/init.d/mysql start
注：sudo运行,不然可能会报错,权限原因；
?

[root@jbxue ~]$? /etc/init.d/mysql start
Starting MySQL.Manager of pid-file quit without updating file.[失败]
?

MYSQL必读2、用命令停止mysql
?

[root@jbxue ~]$ /usr/bin/mysqladmin -u root -pysong shutdown
?

MYSQL必读1：创建用户:
?

CREATE USER ' pig'@'% ' IDENTIFIED BY 'ysong';
[root@jbxue ~]$ mysql -uysong -psong
[root@jbxue ~]$ mysql -uroot -pysong
grant all privileges on e6mall.* to ysong@'%'
grant select,insert,alter,drop on e6mall.* to ysong@"%" identified by "song";
GRANT ALL PRIVILEGES ON e6mall.* TO ysong@"%" IDENTIFIED BY "song";
use mysql;
select user,password from user;
delete from user where user is NULL
update user set password='ysong' where user is 'ysong';

MYSQL必读2：授权:
?

use mysql?
update user set password=password('mysql') where user='root';
update user set password=password('ysong') where user='ysong';
flush privileges;
?

MYSQL必读最后,创建数据库,导入数据库sql文件.
?

mysql -uroot -pysong
create database e6mall;
mysql -uroot -pysong e6mall < /opt/mysql/e6mall.sql;

MYSQL必读至此,就完成了linux下mysql数据库的安装与配置,希望对大家有所赞助.

编程之家PHP培训学院每天发布《Mysql应用linux下mysql数据库安装与配置步骤》等实战技能，PHP、MYSQL、LINUX、APP、JS,CSS全面培养人才。

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!