MySQL-CMD

MySQL user locked

mysql> SELECT user, host, account_locked FROM mysql.user WHERE user = 'viatropi_VTGRP';
+----------------+-------------------------+----------------+
| user           | host                    | account_locked |
+----------------+-------------------------+----------------+
| viatropi_VTGRP | 192.185.4.26            | Y              |
| viatropi_VTGRP | localhost               | Y              |
| viatropi_VTGRP | gator4015.hostgator.com | Y              |
+----------------+-------------------------+----------------+
 
mysql> ALTER USER 'viatropi_VTGRP'@'localhost' ACCOUNT UNLOCK;
Database Backup
mysqldump adamglob_auregagroup > /home/hgtransfer/S-2427064/sourcebup/adamglob_auregagroup.sql
DB import Migration script
dbconnect y1rnbz7u_wrdp8.sql /home1/jamesbi2/srrv.com.ph/wp-config.php

Leave a Comment