Stop mysql
[root@Goautodial ~]# service mysqld stop
Step # 2: Start to MySQL server w/o password:
# mysqld_safe --skip-grant-tables
Output:
[1] 5988 Starting mysqld daemon with databases from /var/lib/mysql mysqld_safe[6025]: started
If the above command get frozen press control + z and then reconect to mysql with no password
root@Goautodial ~]# mysql
mysql> use asterisk;
mysql> update vicidial_users set pass=8123456 where user="admin";
mysql> update phones set pass="hola" where login like '8%';
mysql> update phones set conf_secret="holar" where login like "8%";
asterisk -x " core restart now"
for restart mysql again with password restart the mysql service
service mysqld start
No hay comentarios:
Publicar un comentario