Hi everybody,

I have a fresh mysql installed from source (http://dev.mysql.com/doc/
refman/5.1/de/quick-install.html, sorry, german link, but the commands
should be OK)
System: Buffalo Linkstation 2 (MIPSel)

moved socket and temp path to /usr/local/mysql/var

The GRANT tables has been created (mysql_install_db), but I can't
connect. either as root nor as mysql, with no password and with my
root password:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
ERROR 1045 (28000): Access denied for user 'mysql'@'localhost' (using
password: NO)

I tried to start the server as mysqld and mysqld_safe as root and as
mysql. Everytime the server started but the access is denied.

[1] 652
root@:/usr/local/mysql# 100507 08:04:56 mysqld_safe Logging to '/usr/
local/mysql/var/.exthd..err'.
100507 08:04:57 mysqld_safe Starting mysqld daemon with databases
from /usr/local/mysql/var

what can be the fault? Can you help me please.

Thx
Benjamin

Benjamin Ifland wrote:
> Hi everybody,
> 
> I have a fresh mysql installed from source (http://dev.mysql.com/doc/
> refman/5.1/de/quick-install.html, sorry, german link, but the commands
> should be OK)
> System: Buffalo Linkstation 2 (MIPSel)
> 
> moved socket and temp path to /usr/local/mysql/var
> 
> The GRANT tables has been created (mysql_install_db), but I can't
> connect. either as root nor as mysql, with no password and with my
> root password:
> 
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: NO)
> ERROR 1045 (28000): Access denied for user 'mysql'@'localhost' (using
> password: NO)
> 
> I tried to start the server as mysqld and mysqld_safe as root and as
> mysql. Everytime the server started but the access is denied.
> 
> [1] 652
> root@:/usr/local/mysql# 100507 08:04:56 mysqld_safe Logging to '/usr/
> local/mysql/var/.exthd..err'.
> 100507 08:04:57 mysqld_safe Starting mysqld daemon with databases
> from /usr/local/mysql/var
> 
> what can be the fault? Can you help me please.
> 
> Thx
> Benjamin

Did you define user "root" for the local machine when you installed 
MySQL?  Did you give that user a password?

Also, MySQL users are completely independent of any operating system 
users, even if they have the same user id.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Benjamin Ifland wrote:
> Hi everybody,
> 
> I have a fresh mysql installed from source (http://dev.mysql.com/doc/
> refman/5.1/de/quick-install.html, sorry, german link, but the commands
> should be OK)
> System: Buffalo Linkstation 2 (MIPSel)
> 
> moved socket and temp path to /usr/local/mysql/var
> 
> The GRANT tables has been created (mysql_install_db), but I can't
> connect. either as root nor as mysql, with no password and with my
> root password:
> 
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: NO)
> ERROR 1045 (28000): Access denied for user 'mysql'@'localhost' (using
> password: NO)
> 
> I tried to start the server as mysqld and mysqld_safe as root and as
> mysql. Everytime the server started but the access is denied.
> 
> [1] 652
> root@:/usr/local/mysql# 100507 08:04:56 mysqld_safe Logging to '/usr/
> local/mysql/var/.exthd..err'.
> 100507 08:04:57 mysqld_safe Starting mysqld daemon with databases
> from /usr/local/mysql/var
> 
> what can be the fault? Can you help me please.
> 
> Thx
> Benjamin

I had to reset the mysql root password when I installed it on my linux 
machine.  Somewhere in the install process the password got set without 
my knowing it.  I found some info on the web using Google.  I don't 
recall exactly what I did, but here is one of the links I went to.


http://www.cyberciti.biz/tips/recover-mysql-root-password.html