Ciao a tutti!! ho un poblema con MySql quando da root tento di loggarmi...
[EMAIL PROTECTED]:/home/stecardo# mysql ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) non riesco nemmeno a cambiare la password [EMAIL PROTECTED]:~$ /usr/bin/mysqladmin -u root password 'bestia' /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)' credo ci sia ache qualche problema di configurazione... allego i log di mysql.log e mysql.err grazie in anticipo ste -- S t e f a n o C a r d o Debian GNU/Linux User Linux user 280153 http://www.utenti.lycos.it/stefanocardo ICQ #53379993
Installing all prepared tables 031014 12:55:12 /usr/sbin/mysqld: Shutdown Complete PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h taipollan password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! Please report any problems with the /usr/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com Warning: Ignoring user change to 'mysql' because the user was set to 'mysql' earlier on the command line 031014 12:55:12 /usr/sbin/mysqld: Shutdown Complete 031014 12:55:12 Error at /etc/init.d/mysql\n/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! 031014 12:55:12 mysqld started Warning: Ignoring user change to 'mysql' because the user was set to 'mysql' earlier on the command line /usr/sbin/mysqld: ready for connections. Version: '4.0.15-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306
/usr/sbin/mysqld, Version: 4.0.15-log, started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument 031014 7:39:47 15 Quit 031014 12:13:43 16 Connect [EMAIL PROTECTED] on 16 Quit 031014 12:17:39 17 Connect [EMAIL PROTECTED] on 17 Quit 18 Connect [EMAIL PROTECTED] on 18 Query SHOW VARIABLES LIKE 'pid_file' 18 Shutdown /usr/sbin/mysqld, Version: 4.0.15-log, started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument /usr/sbin/mysqld, Version: 4.0.15-log, started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument /usr/sbin/mysqld, Version: 4.0.15-log, started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument 031014 12:17:43 1 Connect [EMAIL PROTECTED] on 1 Quit 2 Connect [EMAIL PROTECTED] on 2 Quit 031014 12:17:49 3 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 12:21:46 4 Connect [EMAIL PROTECTED] on 4 Quit 5 Connect [EMAIL PROTECTED] on 5 Query SHOW VARIABLES LIKE 'pid_file' 5 Shutdown /usr/sbin/mysqld, Version: 4.0.15-log, started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument 031014 12:22:57 1 Connect [EMAIL PROTECTED] on 1 Quit 2 Connect [EMAIL PROTECTED] on 2 Quit 031014 12:23:04 3 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 12:24:50 4 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 12:27:04 5 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 12:28:30 8 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 12:33:01 9 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 12:34:56 10 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 12:35:18 11 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 12:35:56 12 Connect [EMAIL PROTECTED] on 12 Quit 031014 12:36:23 13 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 12:36:38 14 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 12:36:53 15 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 12:37:07 16 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 12:38:25 17 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 12:39:23 18 Connect [EMAIL PROTECTED] on 18 Statistics 18 Quit 031014 12:39:24 19 Connect [EMAIL PROTECTED] on 19 Statistics 19 Quit 20 Connect [EMAIL PROTECTED] on 20 Query show databases 031014 12:39:25 20 Quit 031014 12:39:41 21 Connect [EMAIL PROTECTED] on mysql 21 Init DB Access denied for user: '[EMAIL PROTECTED]' to database 'mysql' 031014 12:39:54 22 Connect [EMAIL PROTECTED] on mysql 22 Init DB Access denied for user: '[EMAIL PROTECTED]' to database 'mysql' 031014 12:40:03 23 Connect [EMAIL PROTECTED] on mysql 23 Init DB Access denied for user: '[EMAIL PROTECTED]' to database 'mysql' 031014 12:41:49 24 Connect [EMAIL PROTECTED] on 24 Statistics 24 Quit 25 Connect [EMAIL PROTECTED] on 25 Query show databases 25 Quit 031014 12:41:56 26 Connect [EMAIL PROTECTED] on test 26 Init DB test 26 Query show tables 031014 12:41:57 26 Quit 031014 12:42:11 27 Connect [EMAIL PROTECTED] on 27 Quit 28 Connect [EMAIL PROTECTED] on 28 Query SHOW VARIABLES LIKE 'pid_file' 28 Shutdown /usr/sbin/mysqld, Version: 4.0.15-log, started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument 031014 12:42:24 1 Connect [EMAIL PROTECTED] on 1 Quit 2 Connect [EMAIL PROTECTED] on 2 Quit 031014 12:42:28 3 Connect [EMAIL PROTECTED] on 3 Statistics 3 Quit 4 Connect [EMAIL PROTECTED] on 4 Query show databases 4 Quit 031014 12:42:39 5 Connect [EMAIL PROTECTED] on mysql 5 Init DB Access denied for user: '[EMAIL PROTECTED]' to database 'mysql' 031014 12:43:07 6 Connect [EMAIL PROTECTED] on mysql 6 Init DB Access denied for user: '[EMAIL PROTECTED]' to database 'mysql' 031014 12:44:52 7 Connect [EMAIL PROTECTED] on 7 Query show databases 7 Quit 031014 12:48:00 8 Connect [EMAIL PROTECTED] on 8 Statistics 8 Quit 9 Connect [EMAIL PROTECTED] on 9 Query show databases 9 Quit 031014 12:48:34 10 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) 031014 12:48:38 11 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 12:48:40 12 Connect [EMAIL PROTECTED] as anonymous on 12 Query show databases 12 Init DB test 12 Query show tables 12 Init DB Access denied for user: '@localhost' to database 'mysql' 12 Query show databases 031014 12:48:50 12 Quit 031014 12:53:33 13 Connect [EMAIL PROTECTED] on 13 Quit 14 Connect [EMAIL PROTECTED] on 14 Query SHOW VARIABLES LIKE 'pid_file' 14 Shutdown /usr/sbin/mysqld, Version: 4.0.15-log, started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument /usr/sbin/mysqld, Version: 4.0.15-log, started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument /usr/sbin/mysqld, Version: 4.0.15-log, started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument 031014 12:53:35 1 Connect [EMAIL PROTECTED] on 1 Quit 2 Connect [EMAIL PROTECTED] on 2 Quit 031014 12:54:24 3 Connect [EMAIL PROTECTED] on 3 Quit 4 Connect [EMAIL PROTECTED] on 4 Quit 5 Connect [EMAIL PROTECTED] on 5 Quit 6 Connect [EMAIL PROTECTED] on 6 Query SHOW VARIABLES LIKE 'pid_file' 6 Shutdown /usr/sbin/mysqld, Version: 4.0.15-log, started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument /usr/sbin/mysqld, Version: 4.0.15-log, started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument /usr/sbin/mysqld, Version: 4.0.15-log, started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument 031014 12:55:13 1 Connect [EMAIL PROTECTED] on 1 Quit 2 Connect [EMAIL PROTECTED] on 031014 12:55:14 2 Quit 031014 12:57:01 3 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 12:57:21 4 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 12:57:26 5 Connect [EMAIL PROTECTED] as anonymous on 031014 13:02:04 6 Connect [EMAIL PROTECTED] as anonymous on 6 Query show databases 6 Init DB test 6 Query show tables 6 Init DB Access denied for user: '@localhost' to database 'mysql' 6 Query show databases 031014 13:02:17 6 Query flush hosts 031014 13:03:00 6 Init DB Access denied for user: '@localhost' to database 'mysql' 031014 13:03:02 6 Init DB Access denied for user: '@localhost' to database 'mysql' 031014 13:03:05 6 Init DB Access denied for user: '@localhost' to database 'mysql' 031014 13:03:07 6 Init DB Access denied for user: '@localhost' to database 'mysql' 031014 13:03:08 6 Init DB Access denied for user: '@localhost' to database 'mysql' 6 Init DB Access denied for user: '@localhost' to database 'mysql' 6 Init DB Access denied for user: '@localhost' to database 'mysql' 6 Init DB Access denied for user: '@localhost' to database 'mysql' 6 Init DB Access denied for user: '@localhost' to database 'mysql' 031014 13:03:09 6 Init DB Access denied for user: '@localhost' to database 'mysql' 6 Init DB Access denied for user: '@localhost' to database 'mysql' 6 Init DB Access denied for user: '@localhost' to database 'mysql' 6 Init DB Access denied for user: '@localhost' to database 'mysql' 6 Init DB Access denied for user: '@localhost' to database 'mysql' 6 Init DB Access denied for user: '@localhost' to database 'mysql' 031014 13:03:10 6 Init DB Access denied for user: '@localhost' to database 'mysql' 6 Init DB Access denied for user: '@localhost' to database 'mysql' 6 Init DB Access denied for user: '@localhost' to database 'mysql' 6 Init DB Access denied for user: '@localhost' to database 'mysql' 031014 13:03:23 6 Init DB Access denied for user: '@localhost' to database 'mysql' 031014 13:03:28 6 Init DB Access denied for user: '@localhost' to database 'mysql' 031014 13:03:29 6 Init DB Access denied for user: '@localhost' to database 'mysql' 031014 13:03:42 6 Init DB Access denied for user: '@localhost' to database 'mysql' 031014 13:03:43 6 Init DB Access denied for user: '@localhost' to database 'mysql' 031014 13:04:49 7 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 13:05:31 6 Quit 031014 13:05:56 8 Connect [EMAIL PROTECTED] as anonymous on 8 Query SET SQL_SELECT_LIMIT=1,SQL_MAX_JOIN_SIZE=1 8 Query SHOW DATABASES 031014 13:06:18 8 Statistics 8 Statistics 8 Statistics 8 Statistics 8 Statistics 8 Statistics 8 Statistics 8 Statistics 8 Statistics 031014 13:06:25 8 Query CREATE DATABASE IF NOT EXISTS `prova_stecardo` 031014 13:06:40 8 Statistics 8 Statistics 8 Statistics 8 Statistics 8 Statistics 8 Statistics 8 Statistics 8 Statistics 8 Statistics 9 Connect [EMAIL PROTECTED] as anonymous on 9 Query SET SQL_SELECT_LIMIT=1 9 Query SHOW FULL PROCESSLIST 9 Query SHOW GLOBAL VARIABLES 9 Query SHOW GLOBAL VARIABLES LIKE 'have_innodb' 9 Query SHOW STATUS 031014 13:06:52 9 Query FLUSH HOSTS 031014 13:06:56 9 Quit 031014 13:06:58 8 Quit 031014 13:08:18 10 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 13:08:28 11 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 13:15:00 12 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 13:15:33 13 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 13:16:03 14 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 13:16:57 15 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 13:18:18 16 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 13:18:29 17 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 13:18:40 18 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 13:18:57 19 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 031014 13:20:17 20 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)