当前位置:网站首页>Deepinv20 installation MariaDB
Deepinv20 installation MariaDB
2022-04-23 16:36:00 【Sink the wine cup and fleeting time】
DeepinV20 Installation and configuration Mariadb
MySQL
Michael, the founder of · Vidnius led development , Previously 10 A hundred million dollars , Will start their own companies MySQL
Sold to SUN
, thereafter , With SUN
Acquired by Oracle ,MySQL
The ownership of Oracle
In the hands of . Oracle bought it MySQL
after , There will be MySQL
Potential risks of closed sources , So the community USES branching to avoid this risk .
MariaDB
Database management system is MySQL
A branch of , Mostly maintained by the open source community , use GPL licensing
,MariaDB
Of API
and agreement
compatible MySQ
L, In addition, some functions have been added , To support local non blocking operations and progress reporting .
It means , All use MySQL
The connectors 、 Libraries and applications will also be available in MariaDB
Work under the .
install Mariadb
First, you can check whether the system has been installed MariaDB
or MySQL
database
MariaDB
and MySQL
The commands are basically the same
see MariaDB
or MySQL
edition
mysql -V
If no relevant information is displayed , Then use the following command to install , There will be corresponding prompts during installation , Input Y, then Enter You can enter.
install MariaDB
service
sudo apt-get install mariadb-server
install libmariadbclient
( This is generally required for development , No choice )
sudo apt-get install libmariadbclient-dev libssl-dev
Just these two sentences , Installation is complete , You can use commands mysql -V
see MariaDB
Version information , If the installation is successful , There will be corresponding information , Like the following
The next step is MariaDB
Related configuration of
To configure Mariadb
Connect Mariadb
sudo mysql -u root -p
General situation , installed Deepin
After the system , There are no settings root
The user's password , therefore , After entering this command , direct Enter You can enter. ;
If it is already set root
User's password , After entering this command , Will prompt for password , Input root
The user's password is OK
【 expand 】: see root
User's password
sudo cat /etc/mysql/debian.cnf
Linux Everything is a document , I have nothing to do , You can have a look at the contents of these documents
If you can see the following , explain MariaDB
Successful connection
MariaDB
There will be a default name of mysql
The database of , Use mysql
database
use mysql;
The name of the database used at this time is mysql
Mariadb user
Create user
Corresponding statement :create user ' user name '@'%' identified by ' password '
for example : Create user name as bobo
, The password for hh123456
Users of
create user 'bobo'@'%' identified by 'hh123456';
Allow external access MariaDB
Authorization statement :
grant all privileges on Library name . Table name to ‘ user name ’@‘IP Address ’ identified by ‘ password ’ with grant option;
- Library name : The name of the database to be accessed remotely , All databases use
*
- Table name : The name of the table under the database to be accessed remotely , All tables use
*
- user name : The name of the user to assign remote access
- IP Address : Of computers that can be accessed remotely IP Address , All addresses use
%
- password : The password corresponding to the user to be granted remote access
for example : grant bobo
Access rights of external users
grant all privileges on *.* to 'bobo'@'%' identified by 'hh123456' with grant option;
Then refresh the permissions
flush privileges;
At this time, you can also use this statement to see the user's permissions :
select host,user,plugin,authentication_string from user;
%
explain bobo
The user has external access
Mariadb Access to the configuration
Get into etc/mysql/mariadb.conf.d
Under the table of contents
cd etc/mysql/mariadb.conf.d
edit 50-server.cnf
file
Be careful : We must add sudo jurisdiction , Otherwise, the authority is not enough , The change cannot take effect , Temporary files will also be generated
sudo vim 50-server.cnf
Then press i Enter input mode , Sliding roller , Move the cursor to port=3306
It's about , Press backspace ←BackSpace take #
Delete , Move the cursor to... With the mouse bind-address=127.0.0.1
It's about , add #
Comment this line
After modification , Press Esc Key to enter command mode , Then press : Key to enter the last line mode , Input wq
Save and exit vim edit
Restart it Mariadb sudo systemctl restart mysql
Mariadb Start and shut down
- Check the status
sudo systemctl status mysql
- start-up
sudo systemctl start mysql
- restart
sudo systemctl restart mysql
- close
sudo systemctl stop mysql
版权声明
本文为[Sink the wine cup and fleeting time]所创,转载请带上原文链接,感谢
https://yzsam.com/2022/04/202204231402128620.html
边栏推荐
- Government cloud migration practice: Beiming digital division used hypermotion cloud migration products to implement the cloud migration project for a government unit, and completed the migration of n
- On the value, breaking and harvest of NFT project
- RAID磁盘阵列与RAID5的创建
- 通过Feign在服务之间传递header请求头信息
- Sail soft implements a radio button, which can uniformly set the selection status of other radio buttons
- Findstr is not an internal or external command workaround
- About JMeter startup flash back
- Cartoon: what are IAAs, PAAS, SaaS?
- 安装Redis并部署Redis高可用集群
- The first line and the last two lines are frozen when paging
猜你喜欢
G008-hwy-cc-estor-04 Huawei Dorado V6 storage simulator configuration
JMeter setting environment variable supports direct startup by entering JMeter in any terminal directory
JMeter installation tutorial and solutions to the problems I encountered
【Pygame小游戏】10年前风靡全球的手游《愤怒的小鸟》,是如何霸榜的?经典回归......
文件操作详解(2)
建站常用软件PhpStudy V8.1图文安装教程(Windows版)超详细
The solution of not displaying a whole line when the total value needs to be set to 0 in sail software
Cartoon: what are IAAs, PAAS, SaaS?
Review 2021: how to help customers clear the obstacles in the last mile of going to the cloud?
阿里研发三面,面试官一套组合拳让我当场懵逼
随机推荐
What is cloud migration? The four modes of cloud migration are?
What is homebrew? And use
Oracle data pump usage
Postman batch production body information (realize batch modification of data)
NVIDIA显卡驱动报错
基于GPU实例的Nanopore数据预处理
Flask如何在内存中缓存数据?
Hyperbdr cloud disaster recovery v3 Release of version 3.0 | upgrade of disaster recovery function and optimization of resource group management function
Findstr is not an internal or external command workaround
欣旺达:HEV和BEV超快充拳头产品大规模出货
深度学习100例 | 第41天-卷积神经网络(CNN):UrbanSound8K音频分类(语音识别)
漫画:什么是IaaS、PaaS、SaaS?
1959年高考数学真题
Hypermotion cloud migration helped China Unicom. Qingyun completed the cloud project of a central enterprise and accelerated the cloud process of the group's core business system
JSP learning 3
Gartner predicts that the scale of cloud migration will increase significantly; What are the advantages of cloud migration?
Day 10 abnormal mechanism
Creation of RAID disk array and RAID5
Homewbrew installation, common commands and installation path
力扣-198.打家劫舍