Regresar
-
Título
Creating a functional account for MySQL -
Descripción
How to create functional account for MySQL
-
Resolución
Create functional account in MySQL user 'funcacct'@'%' with SELECT and UPDATE privileges on all databases
# mysql -u root mysql
mysql> CREATE USER 'funcacct'@'%' IDENTIFIED BY 'mypass';
Query OK, 0 rows affected (0.00 sec)mysql> GRANT SELECT, UPDATE ON *.* to 'funcacct'@'%';
Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec) -
Solicitud de cambio
BFER2996