Simple Icons contributors / Simple Icons — CC0 1.0
Working notes on MySQL: Authentication, Commands, Export output to file, Function, Import, and Insert, and related topics.
Working notes on MySQL: Authentication, Commands, Export output to file, Function, Import, and Insert, and related topics.
Topics
Authentication
Setting the “authentication plugin” to the older one at the user level is not sufficient if the “default authentication plugin” for the server is set to the newer plugin.
Commands
Shows databases;.
Export output to file
- SELECT order_id,product_name,qty.
Function
Escape.
Import
Import: -u username -p -h 202.54.1.10 <, and --max_allowed_packet=100M.
Insert
Insert: insert into <table> values (‘<value>’|NULL...).
Mac
Exports PATH=$PATH:/usr/local/mysql/bin.
Manage
MySQL status.
Password
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';.
Remote access
http://www.cyberciti.biz/faq/unix-linux-mysqld-server-bind-to-more-than-one-ip-address.
Replace
Replace: UPDATE <table>, and UPDATE SET <column> = REPLACE(<column>, '<existing.
Security
https://docs.oracle.com/cd/E17952_01/refman-5.5-en/security-against-attack.html.
Status
Status: # mysqladmin -u root -p status.
Table Information
Select * from information_schema.tables.
