Programming

Esta página es de solo lectura. Puedes ver la fuente pero no puedes cambiarla. Pregunta a tu administrador si crees que esto es incorrecto.

====== MySQL ======
===== Create users =====

GRANT [type of permission] ON [database name].[table name] TO ‘[username]’@'localhost’;

<code>
mysql> CREATE USER 'finley'@'localhost' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'finley'@'localhost' WITH GRANT OPTION;
</code>
Allow remote connections:
<code>
mysql> CREATE USER 'finley'@'%' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'finley'@'%' WITH GRANT OPTION;
</code>

For example, lets create an access for the user 'mantis' with password 'mantis' only available to connect from 81.4.127.208 to the database mantis:
<code>
create user 'mantis'@'81.4.127.208' identified by 'mantis';
grant all privileges on mantis.* to 'mantis'@'81.4.127.208' with grant option;
flush privileges;
</code>

<code>
FLUSH PRIVILEGES;
</code>

<code>
DROP USER ‘demo’@‘localhost’;
</code>
===== Entrar por consola con user y password =====
-h <host>
<code>
 mysql -u root -h 127.0.0.1 -p
</code>
<code>
mysql -u root -ppassword
</code>

===== Ejecutar commando =====

<code>
mysql -u root -h 127.0.0.1 -ppassword -e "select * from users"
</code>
===== Backups =====
<code>
mysqldump database_name > database_name.sql
</code>
<code>
mysqldump --databases database_one database_two > two_databases.sql
</code>
<code>
mysqldump --all-databases > all_databases.sql
</code>
<code>
mysql database_name < database_name.sql
</code>
**Create a database and load an sql file on it:**
<code>
mysqladmin -u username -p"password" create newDbName
mysql -u username -p"password" newDbName < oldDbName.sql
</code>
<code>
mysql --one-database database_name < all_databases.sql
</code>

Programming

Herramientas de usuario

Herramientas del sitio

Herramientas de la página