SQLPRO FOR SQLITE IMPORT CSV FILE PERMISSIONS PASSWORD
Posted on 16:21 happytian Reading (6) Comments (0) Edit and save to 365Keyġ4: Example 2: MYSQL connected to the remote hostĪssumes that the remote host's IP is 110.110.110.110, the user name is root, and the password is abcd123. Mysql>update MYTBBLE set sex="f" where name='hyq' sql file command (for example D:/mysql.sql) Mysql> LOBD DBTB LODBL INFILE "D:/mysql.txt" INTO TBBLE MYTBBLE ĩ: Import the. Insert records into the table mysql> insert into MYTBBLE values ("hyq","M") Ĩ: Use text Load the data into the database table (for example D:/mysql.txt) Mysql> DREBTE TBBLE MYTBBLE (name VBRDHBR( 20), sex DHBR(1)) Subtables exist in the database at the moment mysql> SHOW TBBLES Mysql> USE MYSQLDBTB (press the Enter key to declare that the operation is successful when Database changed appears!) Mysqlimport -u root -p123456 SHOW DBTBBBSES Is to export the database to a file mysql.dbname in dbname. Such as: mysqldump -u root -p123456 -databases dbname> mysql.dbname Will export the database test database to mysql.test file, which is a text file Display the data table in the database:ģ.
When we change the password and add users, we actually operate on this library.Ģ. The mysql library stores mysql system and user authority information. There are two databases by default: mysql and test. To log on to the mysql, mysql after at the command prompt to run as listed below, each command in minutes The number ends. The fourth one: operation of the database Grant select, insert, update, delete on mydb * to user1 localhost identified by "". If you don't want user1 to have a password, you can make another command to delete the password. Grant select,insert,update,delete on *.* to Identified by "password1" If I hope that the user can land on any machine mysql, change localhost to "%". Grant select, insert, update, delete on *.* to Identified by "password1" First connect to mysql as the root user, and then type the following command: Note that if you are connected to another machine, you need to insert a parameter -h machine IPįormat: grant permission on the database * to username log on the host identified by "password."įor example, to add a password for the user user1 password1, let It can log in on this machine and has the authority to query, insert, modify, and delete all databases. Type the command mysql -uroot -p, After you press Enter, you are prompted to enter the password, enter 12345, and then press Enter to enter mysql. Syntax is as follows: mysql -u user name -p User password Mysql frequently used command-line encyclopedia boil trick, mysql start working and stop doing things
0 kommentar(er)
