Linux服务器安装Mysql的步骤
1.检查软件是否已经安装
rpm -qa|grep -i mysql
2.强制卸载软件
rpm -e --nodeps MySQL-server-5.0.22-0
3.安装Server端
rpm -ivh MySQL-server-5.0.22-0.i386.rpm
安装MySQL服务端的时候报错,报错信息如下:
[root@iZ23k6iktncZ ~]# rpm -ivh MySQL-server-5.0.22-0.i386.rpm
error: Failed dependencies:
ld-linux.so.2 is needed by MySQL-server-5.0.22-0.i386
libc.so.6 is needed by MySQL-server-5.0.22-0.i386
libc.so.6(GLIBC_2.0) is needed by MySQL-server-5.0.22-0.i386
libc.so.6(GLIBC_2.1) is needed by MySQL-server-5.0.22-0.i386
libc.so.6(GLIBC_2.1.2) is needed by MySQL-server-5.0.22-0.i386
libc.so.6(GLIBC_2.1.3) is needed by MySQL-server-5.0.22-0.i386
libc.so.6(GLIBC_2.2) is needed by MySQL-server-5.0.22-0.i386
libcrypt.so.1 is needed by MySQL-server-5.0.22-0.i386
libm.so.6 is needed by MySQL-server-5.0.22-0.i386
libnsl.so.1 is needed by MySQL-server-5.0.22-0.i386
libnss_dns.so.2 is needed by MySQL-server-5.0.22-0.i386
libnss_files.so.2 is needed by MySQL-server-5.0.22-0.i386
libpthread.so.0 is needed by MySQL-server-5.0.22-0.i386
libpthread.so.0(GLIBC_2.0) is needed by MySQL-server-5.0.22-0.i386
libpthread.so.0(GLIBC_2.1) is needed by MySQL-server-5.0.22-0.i386
libpthread.so.0(GLIBC_2.2) is needed by MySQL-server-5.0.22-0.i386
libresolv.so.2 is needed by MySQL-server-5.0.22-0.i386
解决方法(执行下面一行命令):
yum install -y gcc gcc-c++ gcc4-c++ pam-devel
4.如果你安装的机器此时可以连接到互联网,可以跳过第3步使用yum命令来简化安装过程:
yum install mysql-server mysql-devel mysql
yum将自动从centos的镜像站点查找你指明的软件的最新二进制包,并检查软件包依赖关系,安装软件的同时自动安装其依赖的软件包。
5.启动mysqld服务
service mysqld start
6.设置mysql帐号
以root帐号连接到mysql服务器:
mysql -u root
改变当前数据库为mysql:
use mysql
设置从本地主机登录的root帐号密码:
set password for root@localhost=password('your password');
或:
update user set password=password('your password') where user='root' and host='localhost';
删除匿名帐号:
delete from user where user='' ;
删除密码为空的帐号:
delete from user where password='';
删除允许非localhost主机登录的帐号:
delete from user where host<>'localhost' ;
执行下面的命令使更改生效:
flush privileges ;
执行下面的命令退出mysql命令行:
quit 或:exit
7.查看mysql的安装路径
whereis mysql
8.查看mysql版本号
mysql -V 或者 mysql --version
9.设置开机启动
设置开机自启动的方法有很多,例如使用chkconfig命令,
chkconfig mysqld on 设置mysql开机启动
chmod 755 /etc/rc.d/init.d/mysqld 修改mysqld执行权限
另外也可以在/etc/rc.local文件中加上如下MySQL的启动命令,例如:
/etc/rc.d/init.d/mysql start
设置完成后重启系统,使用netstat –nat命令可看到MySQL的3306端口:
[root@iZ23k6iktncZ init.d]# netstat -nat
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 0.0.0.0:8009 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:3690 0.0.0.0:* LISTEN
10.查看数据库目前的编码:show variables like '%char%';
+------------------------------------+-----------------------+
| Variable_name | Value |
+------------------------------------+-----------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+-----------------------------------+----------------------------+
要将其编码修改为utf8,进行一下几步操作:
(1).查找MySQL的cnf文件的位置,执行命令
find / -iname '*.cnf' -print
结果如下:
/etc/my.cnf
/etc/pki/tls/openssl.cnf
/opt/rh/mysql55/root/etc/my.cnf
/opt/rh/mysql55/root/usr/share/doc/mysql55-mysql-server-5.5.36/my-innodb-heavy-4G.cnf
/opt/rh/mysql55/root/usr/share/doc/mysql55-mysql-server-5.5.36/my-huge.cnf
/opt/rh/mysql55/root/usr/share/doc/mysql55-mysql-server-5.5.36/my-large.cnf
/opt/rh/mysql55/root/usr/share/doc/mysql55-mysql-server-5.5.36/my-small.cnf
/opt/rh/mysql55/root/usr/share/doc/mysql55-mysql-server-5.5.36/my-medium.cnf
/opt/rh/mysql55/root/usr/share/mysql/my-innodb-heavy-4G.cnf
/opt/rh/mysql55/root/usr/share/mysql/my-huge.cnf
/opt/rh/mysql55/root/usr/share/mysql/my-large.cnf
/opt/rh/mysql55/root/usr/share/mysql/my-small.cnf
/opt/rh/mysql55/root/usr/share/mysql/my-medium.cnf
/usr/share/doc/mysql-server-5.0.95/my-innodb-heavy-4G.cnf
/usr/share/doc/mysql-server-5.0.95/my-huge.cnf
/usr/share/doc/mysql-server-5.0.95/my-large.cnf
/usr/share/doc/mysql-server-5.0.95/my-small.cnf
/usr/share/doc/mysql-server-5.0.95/my-medium.cnf
/usr/share/mysql/my-innodb-heavy-4G.cnf
/usr/share/mysql/my-huge.cnf
/usr/share/mysql/my-large.cnf
/usr/share/mysql/my-small.cnf
/usr/share/mysql/my-medium.cnf
(2).拷贝 small.cnf、my-medium.cnf、my-huge.cnf、my-innodb-heavy-4G.cnf其中的一个到/etc下,命名为my.cnf
cp /usr/share/mysql/my-medium.cnf /etc/my.cnf,如果出现是否覆盖提示,选择‘y’确定
(3).修改my.cnf
vi /etc/my.cnf
在[client]下添加
default-character-set=utf8
在[mysqld]下添加
default-character-set=utf8
(4).重新启动MySQL
service mysqld restart
(5).再次查看数据库目前的编码:show variables like '%char%';
+----------------------------------+----------------------------+
| Variable_name | Value |
+----------------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+--------------------------------------+
11.查看某个数据库的编码
use mysql
show variables like '%character%';
12.修改某个数据库的编码
alter database mysql character set utf8;
commit;
相关推荐
Linux安装mysql5.7详细步骤,经实践可用。
linux 服务器搭建全套资料 在Linux系统上安装JDK. 在Linux系统上安装Tomcat. 在Linux系统上安装MySQL
该文档主要简单介绍了一下在阿里云地Linux EC服务器上安装mysql数据库地步骤..........
linux服务器配置mysql服务①应用环境②mysql具体安装步骤tomcat服务①在linux安装配置tomcatjdk配置
linux服务器mysql大版本升级操作步骤
安装源文件版本:mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz mysql安装位置:/software/mysql 数据库文件数据位置:/data/mysql 注:未防止混淆,这里都用绝对路径执行命令 除了文件内容中的#,这里所有带#都是...
基于linux7.0以上版本的服务器安装mysql5.7,文档中有安装步骤及操作命令,本人测试安装成功,
本人在网上查询了好多资料,经过两天的实验终于得出正确的安装步骤。安装步骤: 查询以前安装的mysql相关包 rpm -qa | grep mysql 暴力删除这个包 rpm -e mysql-libs-5.1.66-2.el6_3.i686 --nodeps rpm -ivh ...
对于初次在linux服务器部署mysql的同志会有一定的帮助。
云服务器linux CentOS7上安装mysql8,详细内容,云服务器Linux Centos7上安装mysql8的文档是一份详细的安装指南,旨在帮助用户在Linux Centos7操作系统上成功安装和配置MySQL 8数据库。该文档提供了以下内容: 安装...
本文件旨在指导怎么在linux下安装mysql数据库,linux系统在服务器中很常见,而mysql数据库在windows下安装比较简单,但是在linux下安装就需要提前设置好各种环境和变量。
Linux Centos 下使用yum 命令安装mysql实现步骤 1. 查看服务器中有没有安装过Mysql 1. 查看有没有安装包: yum list mysql* #移除已经安装的mysql yum remove mysql mysql-server mysql-libs compat-mysql51 rm...
如何在Linux服务器上安装MYSQL并使用Python脚本来管理数据库 :high_voltage: 如何准备我们Linux服务器 :high_voltage: :star: 步骤1:更新存储库索引。 sudo apt-get update :star: 步骤1:升级存储库索引。 ...
2)也可以自己在网上下载mysql服务,通过xftp传输至Linux系统,自己安装(一般安装在usr或opt目录下) 2.启动数据库 安装完毕,执行命令service mysqld start 3.登录数据库 mysql -u root -p回车后输入密码(mysql...
在linux下面安装mysql如果在/etc下面没有存在my.cnf配置文件 解决方式如下: 1.通过which mysqld命令来查看mysql的安装位置 2.通过/usr/local/mysql/bin/mysqld –verbose –help |grep -A 1 ‘Default options’...
mysql5.7 ARM64 鲲鹏920 银河麒麟V10
玩转Linux服务器搭建(包括jdk+jre+mysql+虚拟机的克隆及虚拟机上网步骤)
1.把压缩包上传到linux服务器并解压 2.使用rpm命令安装mysql服务 rpm -ivh MySQL-server-5.5.55-1.linux2.6.x86_64.rpm 正常则直接去第三步骤,若提示缺少依赖,则用rpm安装压缩包里的那6个perl包 rpm -ivh perl-*...
linux服务器环境搭建详细步骤,jdk、mysql、tomcat、httpd、等安装。
linux操作系统下的mysql服务器搭建步骤详解.docx