Having Problems With Mysql

[Cdn]

what is the defalt password for username root? and how do u change password? for example

Try stopping the mysql daemon

/etc/init.d/mysql stop

Run

mysqld_safe –skip-grant-tables &

Enter as root

mysql -u root -p

To change root password

mysql client – mysql -u root

and write

use mysql

update user set password=PASSWORD(”NEW-ROOT-PASSWORD”) where User=’root’;

where do u put or start this? do u put it in usermane or something? sorry im not a computer export just a newb

[peterlaursen]

The default password for 'root user is EMPTY (nothing). But the MySQL server may have been set up and configured with some script or application defining a password.

If you have lost access to your MySQL server you are close to getting it right. You will have to start MySQL with the –skip-grants-table option. Now you can define details for root (and any user). Next start the server normally.

Full details in MySQL documentation here: http://dev.mysql.com…ermissions.html

[Cdn]

how do you start MySQL with the –skip-grants-table option? sorry im not a good computer person i tryed following the webpage u wrote but im still confussed. ty for your time

[talentsfromindia]

The default password is EMPTY.You may check whether the connection is established and previous session is terminated properly.

[Author]

Posts