[Ilugc] running error in mysql

From: smal@xxxxxxxxxxx (Mahalingam Subramaniam)
Date: Thu Sep 23 12:35:37 2010

                                -- Original Message --

                                From: jaya kumar <jayakumargenius@xxxxxxxxx>

                                To: ilugc@xxxxxxxxxxxxx

                                Date: Thu, 23 Sep 2010 11:38:32 +0530

                                Subject: [Ilugc] running error in mysql



                                i installed mysql successfully



                                [ERROR 1045 (28000): Access denied for user
'root'@'localhost' (using

                                password: NO)]





                                where to modify the changes i selected password
of mysql is --- localhost



                                and



                                another error is





                                if i installed php successfully the error is i
could not save the php script

                                files as normal user



                                [Could not save the file
/var/www/html/local.php.



                                You do not have the permissions necessary to
save the file.



                                Please check that you typed the location
correctly and try again]





                                i installed fedora 13



                                can any one please solve this

                                _______________________________________________

                                ILUGC Mailing List:

                                http://www.ae.iitm.ac.in/mailman/listinfo/ilugc



now check the enclosed text file for changing root password in mysql.

s.mahalingam

"The person addressed in the email is the sole authorized recipient.
Should you receive it in error, immediately notify the sender of the
error and delete the e-mail. Any unauthorized dissemination or copying
of this e-mail (or any attachment to this e-mail) or the wrongful
disclosure of the information herein contained is prohibited.
Also note that this form of communication is not secure, it can be
intercepted, and may not necessarily be free of errors and viruses
in spite of reasonable efforts to secure this medium."
-------------- next part --------------
Solution
---------

This situation arises only when you don't remember root password or entering
wrong password.

1. Stop MySql Server

As a first step, stop the mysql server using the following method:

# service mysql stop (or) # /etc/init.d/mysql stop

2. Please Add,  --skip-grant-tables to mysqld-safe startup command

open the mysql startup script and add skip-grant-tables as shown below.

# vi /etc/rc.d/init.d/mysql

OLD LINE:-
-----------
$bindir/mysqld_Safe --datadir=$datadir --pid-file=$server_pid_file $other_args

/dev/null 2>&1 &

NEW LINE:-
-----------
$bindir/mysqld_safe --skip-grant-tables --datadir=$datadir
-pid-file=$server_pid_file $other_args >/deve/null 2>&1 &

3.Start MySql Server with --skip-grant-tables

start the mysql server with skip-grant tables option which will allow anybody
to login to mysql with out entering a password

#service mysql start
starting MySQL [ OK ]

4. Login using MySQL Root user without entering password

#mysql -u root mysql
(since one has skipped the grant table this time when one try to login to MySQL
it will not ask for passwords)

5.To update mysql root password

<mysql> USER MySQL;
<mysql> UPDATE user SET Password=PASSWORD ('newpassword') WHERE user='root';
<mysql> FLUSH PRIVILEGES;

-----------------------------------------------------------------------------------------------

References:
- [Ilugc] running error in mysql
  - From: jaya kumar

[Ilugc] running error in mysql

Other related posts: