Apache php & MYSQ

[Lee Tambiah]

On 8/18/07, Twaha Daudi <tdmlwilo at yahoo.com> wrote:
>
> Hello all,
> Good day
> Mysql still  not working,.I have not set the password but cant
> login,getting this error
>
> root at NGiveupLaptop:~# mysql -u root
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: NO)
> root at NGiveupLaptop:~# netstat -tap | grep mysql
> tcp        0      0 localhost:mysql         *:*
> LISTEN     4909/mysqld
>
> it is listening on port 4909 instead of 3360.
> Please any help I will appreciate
>
> ------------------------------
>

Hello,

If this is the first time you are attempting to access MySQL then the reason
the above command does not work for you is because no MySQL root password
has been set yet. To log into MySQL for the first time do:-

sudo mysql

Now you are in the MySQL application you can now set your MySQL root
password. Do this by issuing:-

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourPassword');

the quit MySQL with:-

 \q

Now try logging into MySQL as the root user using the password created in
the previous step:-

mysql -u root -p

Regards

Lee Tambiah

ubuntu-users mailing list
ubuntu-users at lists.ubuntu.com
Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20070820/251ca9b9/attachment.html>