Shulou(Shulou.com)06/03 Report--

This article introduces the relevant knowledge of "using shell scripts to connect, read and write, and operate mysql database instances". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

1. Connect to mysql database

The way to connect to a database in shell is simple, just specify the user name, password, and database name of the connection, and then enter the statement of mysql through redirection, as shown below:

The code is as follows:

Mysql-u USERNAME-p PASSWORD DATABASENAME

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.