Problem med MySQL
Postat: 30 maj 2008, 13:28
After installing mysql-server and client I tried to set the root password, starting with this:
$ sudo mysql -uroot -p
[sudo] password for lars:
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Even after I removed, reinstalled and started the server like this:
$ sudo apt-get --purge remove mysql-server
$ sudo apt-get install mysql-server
$ sudo mysqld
the same problem persisted when I tried to login.
I also run the script:
$ sudo /usr/bin/mysql_install_db, but the first reported problem persisted.
Frågan är alltså hur jag får MySQL att fungera under ubunto -- troligen måste jag göra någon mer genomgripande avinstallation och städning... eller?
Would be delighted for some suggestions...
$ sudo mysql -uroot -p
[sudo] password for lars:
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Even after I removed, reinstalled and started the server like this:
$ sudo apt-get --purge remove mysql-server
$ sudo apt-get install mysql-server
$ sudo mysqld
the same problem persisted when I tried to login.
I also run the script:
$ sudo /usr/bin/mysql_install_db, but the first reported problem persisted.
Frågan är alltså hur jag får MySQL att fungera under ubunto -- troligen måste jag göra någon mer genomgripande avinstallation och städning... eller?
Would be delighted for some suggestions...