ir a la carpeta BIN donde esté Mysql instalado (C:\AppServ\MySQL\bin)
escribir -->
mysql -u root -p
(meter la clave de root)
escribir -->
GRANT ALL PRIVILEGES ON *.* TO 'pablo'@'%' IDENTIFIED BY '1234';
(entonces la clave será 1234 y el usuario pablo)
escribir-->
FLUSH PRIVILEGES;
escribir--> quit;
-----------------
FIN :)
-----------------
NOTA:
GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'IP' IDENTIFIED BY 'PASSWORD';
'USERNAME' is the username to be created.
'IP' is the public IP address of the remote connection.
'PASSWORD' is the password to be assigned for this username.
(IP can be replaced with % to allow this user to logon from any host or IP)
