Announcement

Collapse
No announcement yet.

Crear Password MySQL

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Crear Password MySQL

    Crear Password MySQL


    Comandos para crear password MySQL :


    mysql -u root -p
    Luego de dar ENTER, este comando solicitará que ingreses el nuevo password MySQL

    Otro comando similar es:

    mysql_secure_installation

    Ademas, para cambiar el password, mediante comandos MySQL, los pasos serian :

    1) /etc/init.d/mysql stop

    2) mysqld_safe --skip-grant-tables &

    3) mysql -u root

    4) Setup new MySQL root user password
    use mysql;

    update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
    flush privileges;
    quit

    5) Stop MySQL Server: /etc/init.d/mysql stop

    6) Start MySQL server and test it: mysql -u root -p
    Last edited by soporte; 04-27-2016, 06:45 PM.
Working...
X