How to find out the username and password for mysql database

Question

I ve forgotten what I set as username and password for mysql database  How could I be able to find it out  I am using wamp server  I am a newbie in mysql

User · Answer

Assuming that the user you are using in phpmyadmin has the necessary privileges  you can run this query to change the root password   UPDATE mysql user SET Password PASSWORD  MyNewPass   WHERE User  root   FLUSH PRIVILEGES

User · Answer

Open phpmyadmin  go to database and corresponding table to find it out

User · Answer

Go to this file in  WampFolder apps phpmyadmin phpmyadmin version  config inc php  Usually wamp is in your main hard drive folder C  wamp   You will see something like    cfg  Servers    i   user      YOUR USER NAME IS HERE    cfg  Servers    i   password      AND YOU PASSWORD IS HERE     Try using the password and username that you have on that file

User · Answer

One of valid JDBC url is   jdbcUrl jdbc mysql   localhost 3306 wsmg user root amp password root

User · Answer

In your local system right      go to this url   http   localhost phpmyadmin      In this click mysql default db  after that browser user table to get existing username and password

User · Answer

If you forget your password for SQL plus 10g then follow the steps     START Type RUN in the search box Type  cnc  in the box captioned as OPEN and a black box will appear 4 There will be some text already in the box   C  Users admin   Just beside that start typing  sqlplus nolog  press ENTER key On the next line type  conn sys change on install as sysdba   press ENTER  6  in the next line after sql-  type   alter user scott account unlock    Now open your slpplus and type user name as  scott  and password as  tiger      If it asks your old password then type the one you have given while installing

User · Answer

There are two easy ways     In your cpanel Go to cpanel  softaculous  wordpress  under the current installation  you will see the websites you have installed with the wordpress  Click the  edit detail  of the particular website and you will see your SQL database username and password  In your server Access your FTP and view the wp-config php

[mysql] How to find out the username and password for mysql database

Examples related to mysql

Examples related to passwords