1. Forum
  2. Usenet
  3. LINUX.DEBIAN.USER.PORTUGU

  • Re: OFF TOPIC - Problemas com mysql (2/2)

    From Mauricio Neto@21:1/5 to All on Tue Apr 26 01:20:02 2022
    [continued from previous message]

    $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED
    |<br>
    | root             | localhost
    |                                                                       
    |<br> +------------------+-----------+------------------------------------------------------------------------+<br>
    4 rows in set (0,00 sec)<br>
    <br>
    ===============================================<br>
    ================================================<br>
    ================ FIM ==============================
      <br>
      <br>
    </div>
    </blockquote>
    </div>
    </blockquote>
    <br>
    </div>
    </blockquote>
    </div>
    </blockquote>
    </body>
    </html>

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Mauricio Neto@21:1/5 to All on Wed Apr 27 05:50:02 2022
    [continued from previous message]

    Defino uma senha para root mas ela não é criada
    ....<br>
    <br>
    mysql&gt; select user, host, authentication_string
    from mysql.user;<br> +------------------+-----------+------------------------------------------------------------------------+<br>
    | user             | host      |
    authentication_string                                                 
    |<br> +------------------+-----------+------------------------------------------------------------------------+<br>
    | mysql.infoschema | localhost |
    $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED
    |<br>
    | mysql.session    | localhost |
    $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED
    |<br>
    | mysql.sys        | localhost |
    $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED
    |<br>
    | root             | localhost
    |                                                                       
    |<br> +------------------+-----------+------------------------------------------------------------------------+<br>
    4 rows in set (0,00 sec)<br>
    <br>
    mysql&gt; ALTER USER 'root'@'localhost' IDENTIFIED
    BY 'criandosenha';<br>
    Query OK, 0 rows affected (0,00 sec)<br>
    <br>
    mysql&gt; FLUSH PRIVILEGES;<br>
    Query OK, 0 rows affected (0,01 sec)<br>
    <br>
    mysql&gt; select user, host, authentication_string
    from mysql.user;<br> +------------------+-----------+------------------------------------------------------------------------+<br>
    | user             | host      |
    authentication_string                                                 
    |<br> +------------------+-----------+------------------------------------------------------------------------+<br>
    | mysql.infoschema | localhost |
    $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED
    |<br>
    | mysql.session    | localhost |
    $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED
    |<br>
    | mysql.sys        | localhost |
    $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED
    |<br>
    | root             | localhost
    |                                                                       
    |<br> +------------------+-----------+------------------------------------------------------------------------+<br>
    4 rows in set (0,00 sec)<br>
    <br>
    ===============================================<br>
    ================================================<br>
    ================ FIM
    ==============================   <br>
      <br>
    </div>
    </blockquote>
    </div>
    </blockquote>
    <br>
    </div>
    </blockquote>
    </div>
    </blockquote>
    </blockquote>
    <br>
    </body>
    </html>

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)