ciao<br>premesso che non ci capisco nulla di database<br><br>ho bisogno di installare su una macchina il CMS Joomla, che richede mysql<br>ho installato apt-get install mysql-server<br>ma c'e' qualcosa che non va, quando compilo la maschera dell'installazione di joomla sul DB mi dice sempre che ho inserito username o password errate
<br><br>riporto ps, qualche test e syslog<br><br>qualche buon'anima mi da' una dritta?<br><br>grssie e buon week end<br><br>gg<br>--------------------------<br><br>#ps<br>root 32640 0.0 2.2 3536 1372 ? S Jun28 0:00 /bin/sh /usr/bin/mysqld_safe
<br>mysql 410 0.5 26.3 127536 16360 ? Sl 00:22 5:58 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/m
<br>ysqld/mysqld.pid --skip-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock<br>root 411 0.0 1.0 2632 640 ? S 00:22 0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld<br><br><br><br>root@grop
:~ # mysqlshow<br>mysqlshow: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)<br>root@grop:~ # mysqltest<br>mysqltest: Could not open connection 'default': 2002 Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
<br>not ok<br><br>#quando riavvio mysql nel syslog trovo:<br><br>Jun 29 18:32:49 grop mysqld[1666]: 070629 18:32:49 InnoDB: Started; log sequence number 0 43655<br>Jun 29 18:32:50 grop mysqld[1666]: 070629 18:32:50 [Note] /usr/sbin/mysqld: ready for connections.
<br>Jun 29 18:32:50 grop mysqld[1666]: Version: '5.0.24a-Debian_9ubuntu2-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Debian etch distribution<br>Jun 29 18:32:54 grop /etc/mysql/debian-start[1720]: Checking for crashed MySQL tables.
<br>Jun 29 18:32:55 grop /etc/mysql/debian-start[1728]: Upgrading MySQL tables if necessary.<br>Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: /usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.
<br>sock' (111) when trying to connect<br>Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: This script updates all the mysql privilege tables to be usable by<br>Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: MySQL
4.0 and above.<br>Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]:<br>Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: This is needed if you want to use the new GRANT functions,<br>Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: CREATE AGGREGATE FUNCTION, stored procedures, or
<br>Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: more secure passwords in 4.1<br>Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]:<br>Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: /usr/bin/mysql_fix_privilege_tables: line 190: 1756 Broken pipe cat $sql_file
<br>Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: 1757 Segmentation fault | $cmd >/dev/null 2>&1<br>Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: Got a failure from command:<br>Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: cat /usr/share/mysql/mysql_fix_privilege_tables.sql | /usr/bin/mysql --no-defaults --force --user=deb
<br>ian-sys-maint --host=localhost --password=BStHgvGoV7TL1Gtj --database=mysql<br>Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: Please check the above output and try again.<br>Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]:
<br>Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: Running the script with the --verbose option may give you some information<br>Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: of what went wrong.<br>Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]:
<br>Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: If you get an 'Access denied' error, you should run this script again and<br>Jun 29 18:32:56 grop /etc/mysql/debian-start[1731]: give the MySQL root user password as an argument with the --password= option
<br><br><br>