How to use MySQL in Linux
This article will explain in detail how to use MySQL in Linux. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.
1.show databases
2.use mysql conversion database
3.show tables displays tables in the database
4.select user,host,password from user queries the user,host,password of my database mysql
5. Set a password for the account
Mysql > update user set password=password ('123456') where user='root'
6. Clear empty user
Delete From user where user=''
7. View the remaining users
Command the same query user command as above
8. Refresh permissions (focus)
Command flush privileges; to refresh permissions after each operation!
9. Access the database through the user
Mysql-u root-p123456; (all passwords after-p)
10. Edit the .bash _ profile file (this step allows us to use which mysql to directly find out where the mysql file is)
Vi . Change bash_profile to # .bash _ profile
# Get the aliases and functions
If [- f ~ / .bashrc]; then
. ~ / .bashrc
Fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
1,1 Top
# .bash _ profile
# Get the aliases and functions
If [- f ~ / .bashrc]; then
. ~ / .bashrc
Fi
# User specific environment and startup programs
Export MYSQL_BASE=/usr/local/mysql
Export PATH=$ {MYSQL_BASE} / bin:$PATH
PS1= `uname-n` ":"'$USER' ":"'$PWD' ": >"; export PS1 gets the result
11. Create a new database and set up access to his machine
11.1 create database ruozedb; create database ruozedb
11.2grant all privileges on ruozedb.* to ruoze@'192.168.137.252' identified by '123456' only users whose IP is 192.168.137.252 are allowed to access the database ruozedb with a password of 123456 (if the IP address is changed to%, any ID can be accessed by ruoze users)
11.3flush privileges; permission refresh
The practice is shown in the figure:
twelve。 Connect Dbeaver
This is the end of the article on "how to use MySQL in Linux". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.
