Access denied for user 'root'@'localhost' (using password: NO)
Jag har en LAMP-server (Ubuntu Server 6.10) som jag har lagt till dessa program/servrar på:
proftpd
webmin
phpmyadmin
torrentflux
ssh
nfs
samba
Problemet kommer egenligen när jag ska köra uppgrade filen som skriver om databasen till version 2.1-2.2 Torrenflux:
Kod: Markera allt
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO) in /usr/share/torrentflux/www/upgrade21_22.php on line 22Kod: Markera allt
nimda@l3bserv:~$ mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
När jag kör sudo mysql -p så kommer jag in men det hjälper ju inte.
Hursomhelst så har jag löst detta problem själv förut genom google osv, då jag har använt mig utav dessa how-to's:
http://dev.mysql.com/doc/refman/5.0/en/ ... sions.html
https://help.ubuntu.com/community/MysqlPasswordReset
Har provat att köra dessa guider och det fungerar fortfarande inte.
Den gången jag fixade detta problem förut gjorde jag såhär:
1.
Log on to your system as either the Unix root user or as the same user that the mysqld server runs as.
2.
Locate the .pid file that contains the server's process ID. The exact location and name of this file depend on your distribution, hostname, and configuration. Common locations are /var/lib/mysql/, /var/run/mysqld/, and /usr/local/mysql/data/. Generally, the filename has the extension of .pid and begins with either mysqld or your system's hostname.
You can stop the MySQL server by sending a normal kill (not kill -9) to the mysqld process, using the pathname of the .pid file in the following command:
shell> kill `cat /mysql-data-directory/host_name.pid`
Note the use of backticks rather than forward quotes with the cat command; these cause the output of cat to be substituted into the kill command.
3.
Create a text file and place the following command within it on a single line:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');
Save the file with any name. For this example the file will be ~/mysql-init.
4.
Restart the MySQL server with the special --init-file=~/mysql-init option:
shell> mysqld_safe --init-file=~/mysql-init &
The contents of the init-file are executed at server startup, changing the root password. After the server has started successfully you should delete ~/mysql-init.
5.
You should be able to connect using the new password.
Och det fungerade klockrent, men jag kan inte, av någon anledning, exekvera detta kommando utan felmeddelande:
Kod: Markera allt
nimda@l3bserv:~$ sudo kill `cat /var/run/mysqld/mysqld.pid`
cat: /var/run/mysqld/mysqld.pid: Permission denied
Usage:
kill pid ... Send SIGTERM to every process listed.
kill signal pid ... Send a signal to every process listed.
kill -s signal pid ... Send a signal to every process listed.
kill -l List all signal names.
kill -L List all signal names in a nice table.
kill -l signal Convert between signal numbers and names.
Jag har provat att stänga ner demonen på alla möjliga andra sätt, men inget funkar.
Så antingen måste jag få igång på detta kommando, eller hitta ett annat sätt att komma runt detta problem.
Hjälp mig att få detta att fungera:
Kod: Markera allt
sudo kill `cat /var/run/mysqld/mysqld.pid`
Tack på förhand.
