Fw: [Sussex] Setting up MySQL under FC6

[Brendan Whelan]

I played around further and found that
mysql -u anonymous
allowed me to login.
>From this I implied that the localhost/127.0.0.1 must be set correctly so
the fault could simply be that I have an unknown password for root.

I therefore did the following to reset the password:


            service mysqld stop



            cd /bin



            mysqld_safe –user=mysql –skip-grant-tables &



            (Needed an extra return !)



            mysql –u root mysql



            update user set password=password(‘my_password”) where user=
“root”;


            exit

            service mysqld stop
            service mysqld start



            mysql -u root -p

            When prompted I entered the password.



            I was then allowed access.



Matt, thanks for you advice and support.   Brendan



> Matt,
>
> As requested, below is the information in the log file - as can be seen I
> had two attempts at logging in.
>
> Any suggestions?  Brendan
> --------------------------------------------------------------------------
--
> ----------------------
> [root at mountain ~]# tail -n 50 /var/log/mysql/mysql.log
>
> /usr/libexec/mysqld, Version: 5.0.27-log. started with:
>
> Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock
>
> Time Id Command Argument
>
> 070530 8:38:36 1 Connect UNKNOWN_MYSQL_US at localhost as anonymous on
>
> 1 Quit
>
> 070530 8:38:46 2 Connect Access denied for user 'root'@'localhost' (using
> password: YES)
>
> 070530 8:39:54 3 Connect Access denied for user 'root'@'localhost' (using
> password: YES)
>
>
>
>