Mysql root problems!!
Ciao a tutti!!
ho un poblema con MySql
quando da root tento di loggarmi...
root@taipollan:/home/stecardo# mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using password:
YES)
non riesco nemmeno a cambiare la password
stecardo@taipollan:~$ /usr/bin/mysqladmin -u root password 'bestia'
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (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 debian-sys-maint@localhost on
16 Quit
031014 12:17:39 17 Connect debian-sys-maint@localhost on
17 Quit
18 Connect debian-sys-maint@localhost 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 debian-sys-maint@localhost on
1 Quit
2 Connect debian-sys-maint@localhost on
2 Quit
031014 12:17:49 3 Connect Access denied for user: 'root@localhost' (Using password: YES)
031014 12:21:46 4 Connect debian-sys-maint@localhost on
4 Quit
5 Connect debian-sys-maint@localhost 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 debian-sys-maint@localhost on
1 Quit
2 Connect debian-sys-maint@localhost on
2 Quit
031014 12:23:04 3 Connect Access denied for user: 'root@localhost' (Using password: YES)
031014 12:24:50 4 Connect Access denied for user: 'root@localhost' (Using password: YES)
031014 12:27:04 5 Connect Access denied for user: 'root@localhost' (Using password: YES)
031014 12:28:30 8 Connect Access denied for user: 'root@localhost' (Using password: YES)
031014 12:33:01 9 Connect Access denied for user: 'root@localhost' (Using password: YES)
031014 12:34:56 10 Connect Access denied for user: 'root@localhost' (Using password: YES)
031014 12:35:18 11 Connect Access denied for user: 'root@localhost' (Using password: YES)
031014 12:35:56 12 Connect debian-sys-maint@localhost on
12 Quit
031014 12:36:23 13 Connect Access denied for user: 'root@localhost' (Using password: YES)
031014 12:36:38 14 Connect Access denied for user: 'admin@localhost' (Using password: YES)
031014 12:36:53 15 Connect Access denied for user: 'admin@localhost' (Using password: YES)
031014 12:37:07 16 Connect Access denied for user: 'admin@localhost' (Using password: YES)
031014 12:38:25 17 Connect Access denied for user: 'root@localhost' (Using password: YES)
031014 12:39:23 18 Connect debian-sys-maint@localhost on
18 Statistics
18 Quit
031014 12:39:24 19 Connect debian-sys-maint@localhost on
19 Statistics
19 Quit
20 Connect debian-sys-maint@localhost on
20 Query show databases
031014 12:39:25 20 Quit
031014 12:39:41 21 Connect debian-sys-maint@localhost on mysql
21 Init DB Access denied for user: 'debian-sys-maint@localhost' to database 'mysql'
031014 12:39:54 22 Connect debian-sys-maint@localhost on mysql
22 Init DB Access denied for user: 'debian-sys-maint@localhost' to database 'mysql'
031014 12:40:03 23 Connect debian-sys-maint@localhost on mysql
23 Init DB Access denied for user: 'debian-sys-maint@localhost' to database 'mysql'
031014 12:41:49 24 Connect debian-sys-maint@localhost on
24 Statistics
24 Quit
25 Connect debian-sys-maint@localhost on
25 Query show databases
25 Quit
031014 12:41:56 26 Connect debian-sys-maint@localhost on test
26 Init DB test
26 Query show tables
031014 12:41:57 26 Quit
031014 12:42:11 27 Connect debian-sys-maint@localhost on
27 Quit
28 Connect debian-sys-maint@localhost 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 debian-sys-maint@localhost on
1 Quit
2 Connect debian-sys-maint@localhost on
2 Quit
031014 12:42:28 3 Connect debian-sys-maint@localhost on
3 Statistics
3 Quit
4 Connect debian-sys-maint@localhost on
4 Query show databases
4 Quit
031014 12:42:39 5 Connect debian-sys-maint@localhost on mysql
5 Init DB Access denied for user: 'debian-sys-maint@localhost' to database 'mysql'
031014 12:43:07 6 Connect debian-sys-maint@localhost on mysql
6 Init DB Access denied for user: 'debian-sys-maint@localhost' to database 'mysql'
031014 12:44:52 7 Connect debian-sys-maint@localhost on
7 Query show databases
7 Quit
031014 12:48:00 8 Connect debian-sys-maint@localhost on
8 Statistics
8 Quit
9 Connect debian-sys-maint@localhost on
9 Query show databases
9 Quit
031014 12:48:34 10 Connect Access denied for user: 'debian-sys-maint@localhost' (Using password: NO)
031014 12:48:38 11 Connect Access denied for user: 'root@localhost' (Using password: YES)
031014 12:48:40 12 Connect stecardo@localhost 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 debian-sys-maint@localhost on
13 Quit
14 Connect debian-sys-maint@localhost 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 debian-sys-maint@localhost on
1 Quit
2 Connect debian-sys-maint@localhost on
2 Quit
031014 12:54:24 3 Connect debian-sys-maint@localhost on
3 Quit
4 Connect debian-sys-maint@localhost on
4 Quit
5 Connect debian-sys-maint@localhost on
5 Quit
6 Connect debian-sys-maint@localhost 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 debian-sys-maint@localhost on
1 Quit
2 Connect debian-sys-maint@localhost on
031014 12:55:14 2 Quit
031014 12:57:01 3 Connect Access denied for user: 'root@localhost' (Using password: YES)
031014 12:57:21 4 Connect Access denied for user: 'taipollan@localhost' (Using password: YES)
031014 12:57:26 5 Connect taipollan@localhost as anonymous on
031014 13:02:04 6 Connect stecardo@localhost 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: 'root@localhost' (Using password: YES)
031014 13:05:31 6 Quit
031014 13:05:56 8 Connect stecardo@localhost 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 stecardo@localhost 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: 'root@localhost' (Using password: YES)
031014 13:08:28 11 Connect Access denied for user: 'root@localhost' (Using password: YES)
031014 13:15:00 12 Connect Access denied for user: 'root@localhost' (Using password: YES)
031014 13:15:33 13 Connect Access denied for user: 'root@localhost' (Using password: YES)
031014 13:16:03 14 Connect Access denied for user: 'root@localhost' (Using password: YES)
031014 13:16:57 15 Connect Access denied for user: 'root@localhost' (Using password: YES)
031014 13:18:18 16 Connect Access denied for user: 'root@localhost' (Using password: YES)
031014 13:18:29 17 Connect Access denied for user: 'root@localhost' (Using password: YES)
031014 13:18:40 18 Connect Access denied for user: 'root@localhost' (Using password: YES)
031014 13:18:57 19 Connect Access denied for user: 'root@localhost' (Using password: YES)
031014 13:20:17 20 Connect Access denied for user: 'root@localhost' (Using password: YES)
Reply to: