在Ubuntu上手动部署mariadb数据库环境

分类:随笔 日期:2020-09-04 作者:caocaofff 浏览:1107

先假设工作目录在/data/bin

mkdir -p /data/bin
cd /data/bin
#添加用户
groupadd mysql
useradd -s /sbin/nologin -g mysql mysql
#环境变量
vim /etc/profile

export MARIADB=/usr/local/mysql
export PATH=$MARIADB/bin:$PATH
最新版mariadb数据库下载地址:http://ftp.hosteurope.de/mirror/archive.mariadb.org/

wget http://ftp.hosteurope.de/mirror/archive.mariadb.org/mariadb-10.5.5/bintar-linux-systemd-x86_64/mariadb-10.5.5-linux-systemd-x86_64.tar.gz
tar -zxf mariadb-10.5.5-linux-systemd-x86_64.tar.gz
cd mariadb-10.5.5-linux-systemd-x86_64
#目录权限
chown -R root:root .
chown -R mysql data
#目录必须是绝对路径
ln -sf /data/bin/mariadb-10.5.2-linux-systemd-x86_64 /usr/local/mysql
#复制配置文件,非必须
cp support-files/my-small.cnf /etc/my.cnf

如果提示缺少libaio.so.1可以

apt install libaio1 libncurses5

先初始化

./scripts/mysql_install_db --user=mysql

启动服务

cp support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
/etc/init.d/mysqld start
#服务自启动
update-rc.d mysqld defaults

开始安装

/usr/local/mysql/bin/mysql_secure_installation

以下是设置的参考:

Enter current password for root (enter for none):<–初次运行直接回车 OK, successfully
Set root password? [Y/n] <– 是否设置root用户密码,输入y并回车或直接回车
New password: <– 设置root用户的密码
Re-enter new password: <– 再输入一次你设置的密码
Remove anonymous users? [Y/n] <–是否删除匿名用户,生产环境建议删除,所以直接回车
Disallow root login remotely? [Y/n] <–是否禁止root远程登录,根据自己的需求选择Y/n并回车,建议禁止
Remove test database and access to it? [Y/n] <– 是否删除test数据库,直接回车
Reload privilege tables now? [Y/n] <–是否重新加载权限表,直接回车
vim /etc/my.cnf

修改默认编码为utf8mb4:

[client]
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4
[mysqld]
collation-server = utf8mb4_unicode_ci
init-connect=SET NAMES utf8mb4
character-set-server = utf8mb4
bind-address = 127.0.0.1

重启服务

/etc/init.d/mysqld stop
service mysqld start

登陆

/usr/local/mysql/bin/mysql -uroot -p

查看编码(登录后):

MariaDB [(none)]> show variables like 'character%';
+--------------------------+---------------------------------------------------------------+
| Variable_name            | Value                                                         |
+--------------------------+---------------------------------------------------------------+
| character_set_client     | utf8mb4                                                       |
| character_set_connection | utf8mb4                                                       |
| character_set_database   | utf8mb4                                                       |
| character_set_filesystem | binary                                                        |
| character_set_results    | utf8mb4                                                       |
| character_set_server     | utf8mb4                                                       |
| character_set_system     | utf8mb3                                                       |
| character_sets_dir       | /data/bin/mariadb-10.6.3-linux-systemd-x86_64/share/charsets/ |
+--------------------------+---------------------------------------------------------------+
8 rows in set (0.002 sec)



CC版权: 本篇博文采用《CC 协议》,转载必须注明作者和本文链接

评论 (暂无评论)

发表评论

昵称:  
邮箱:  
网址: