hola he borrado accdidentalmente
el usuario root de mysql desde el phpadmin, por consiguiente no puedo entrar a mi ispconfig, he intentado restaurarlo pero no hepodido, use lo siguiente
[root@D2645 ~]# killall mysqld
[root@D2645 ~]# /usr/libexec/mysqld --skip-grant-tables --user=root &
[1] 16941
[root@D2645 ~]# 071023 18:59:17 InnoDB: Started; log sequence number 0 43665
071023 18:59:17 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.27' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.27
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> USE mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> update user set password=password("YOUSETPASSWORD") Where user="root";
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3 Changed: 3 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
[root@D2645 ~]# killall mysqld
071023 19:00:57 [Note] /usr/libexec/mysqld: Normal shutdown
[root@D2645 ~]# 071023 19:00:57 InnoDB: Starting shutdown...
071023 19:01:00 InnoDB: Shutdown completed; log sequence number 0 43665
071023 19:01:00 [Note] /usr/libexec/mysqld: Shutdown complete
mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[1]+ Done /usr/libexec/mysqld --skip-grant-tables --user=root
[root@D2645 ~]# /etc/init.d/mysqld start
Starting MySQL: [ OK ]
[root@D2645 ~]# mysql -u root -p
Enter password:YOUSETPASSWORD
Access denied for user 'root'@'localhost' (using password: YES)
he intentado de todo pero simplemente no me cambia el nombre de root, no se si por el isp es diferente, pero ponga lo que le ponga sique saliendo
Access denied for user 'root'@'localhost' (using password: YES)
ayuuudaaaaaaaa
