Infortel
Home
Infortel
History
Vision and Mission
Publications
Support
Permanent technical support
Technical Support via Internet
Descargas
Informational Brochure (english)
Informational Brochure (spanish)
Professional Version
Corporate Version
Enterprise Version (Web)
Utility Program Siscon Attached
Special
CLIENT services
Technical support connection
Specialized support
References
Linux: Web Reference
Linux: Linux utility commands
Linux: MySQL utility commands
Contact us
Language
English
Spanish
#
Name
Description
1
Activate MySQL to be used in the network.
Edit file /etc/my.cnf
Indicate comment to the line: skip-networking
2
Create database
create database NAME
3
Assign user permit to access the system from anywhere.
use mysql
update user set host='%' where user='root'
Assign password: update user set password=password('PASSWORD') where user='root'
flush privileges
4
Delete database
drop database NAME
5
Data location
/var/lib/mysql/
6
View databases
show databases
7
View tables
show tables
UTILITY QUERY TO SETUP
To execute a command copy to the clipboard (CTRL-C), then on the terminal screen press right button to paste
USER LIST
use mysql;
select user,password,host from user;
OPEN USER PRIVILEGES
update user set
Select_priv='Y', Insert_priv='Y', Update_priv='Y', Delete_priv='Y', Create_priv='Y', Drop_priv='Y', Reload_priv='Y', Shutdown_priv='Y',
Process_priv='Y', File_priv='Y', Grant_priv='Y', References_priv='Y', Index_priv='Y', Alter_priv='Y', Show_db_priv='Y',
Super_priv='Y', Create_tmp_table_priv='Y', Lock_tables_priv='Y', Execute_priv='Y', Repl_slave_priv='Y', Repl_client_priv='Y',
ssl_type='Y', ssl_cipher='Y', x509_issuer='Y', x509_subject='Y', max_questions=0, max_updates=0, max_connections=0
where user=
'USERID'