Il risultato da terminale di
codice:
sudo ls -l /var/lib/mysql
è:
codice:
totale 20488 -rw-r--r-- 1 mysql mysql 0 2011-02-08 19:24 debian-5.1.flag -rwxrwxrwx 1 mysql mysql 10485760 2011-02-08 21:09 ibdata1 -rw-rw---- 1 mysql mysql 5242880 2011-02-08 21:09 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 2010-12-16 20:08 ib_logfile1 drwxrwxrwx 2 mysql mysql 4096 2011-02-08 19:24 mysql -rwxrwxrwx 1 mysql mysql 6 2010-12-16 20:08 mysql_upgrade_info
Nel frattempo ho provato a seguire questa http://micheleb26.wordpress.com/2009...edir-di-mysql/ guida passo per passo, ho riavviato il pc, avviato sudo service mysql start, aperto il workbench, aperto la connessione col database e...
codice:
Cannot Connect to Database Server Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 Please: 1 Check that mysql is running on server 127.0.0.1 2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed) 3 Check the root has rights to connect to 127.0.0.1 from your address (mysql rights define what clients can connect to the server and from which machines) 4 Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you're connecting from