2,306
edits
Changes
Jump to navigation
Jump to search
mLine 1:
Line 1: − + − + − show databases; + − + − use dbname; + − connect dbname; + − + − show tables; + − + + + + + + + − + Line 22:
Line 28: + + + + + + + + + + + + + + + + + + + + + + +
→Grant Access to Database
== SQL ==
==SQL==
=== List databases ===
===List databases===
SHOW databases;
=== Open db ===
===Open db===
USE dbname;
or
or
CONNECT dbname;
=== List tables ===
===List tables===
SHOW TABLES;
=== add .sql to MySQL database ===
===Show table fields===
SHOW COLUMNS FROM City;
DESCRIBE City;
===add .sql to MySQL database===
TODO: REVISAR
TODO: REVISAR
backup:
backup:
mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql
mysqldump -u root -p[root_password] [database_name] [table1 table2 ...]> dumpfilename.sql
backup .sql.gz
backup .sql.gz
mysql -uroot -ppassword mydb > myfile.sql.gz
mysql -uroot -ppassword mydb > myfile.sql.gz
restore .sql.gz
restore .sql.gz
zcat /path/to/file.sql.gz | mysql -u 'root' -p 'password' your_database
zcat /path/to/file.sql.gz | mysql -u 'root' -p 'password' your_database
===Save SELECT to file===
SELECT hostname FROM VTS_sistema WHERE INTO LOCAL OUTFILE '/tmp/hostnames_VTS_sistema' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
mysql -h20.1.40.66 -u xe50582 -p -D workflow -e "SELECT hostname FROM controles_sistemas WHERE cod_plataforma='UNX'" > hostnames_unix_workflow.txt
===Create User===
<syntaxhighlight lang="sql">
CREATE USER 'owncloud'@'localhost' IDENTIFIED BY 'password';
</syntaxhighlight>
===Grant Access to Database===
<syntaxhighlight lang="sql">
GRANT ALL ON owncloud.* TO 'ownclouduser'@'localhost' IDENTIFIED BY '4yRQpHDju5WdecKp8WrK' WITH GRANT OPTION;
FLUSH PRIVILEGES;
EXIT;
</syntaxhighlight>
===Change DB password===
SET PASSWORD [FOR user] = password_option
SET PASSWORD FOR 'jeffrey'@'localhost' = password_option;
TODO: https://www.zeppelinux.es/corregir-error-1698-28000-access-denied-for-user-rootlocalhost-en-mariadb-mysql/