This question already has an answer here: • 1 answer I am trying to connect to a remote mysql database from my local box. Initially I was not even able to hit the mysql db. But after commenting the binding_address in the my.cnf file and restarting the mysql server, I am now able to hit it. But now, I am getting an Access denied error mysql -u root -h x.x.x.x -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'x.x.x.x' (using password: YES) Is my IP being blacklisted or something? I wish Apple wouldn't bury it so deeply, and I wish Apple would create an app for older users to walk them through some of the accessibility features that may be helpful to them; what I find, especially, is that older users tend not to like to think they need help, don't like the word 'accessibility'—call it excessive pride, I dunno—but if you reframe the features as just 'configuring your environment for you, for what you need and do', they're fine with it, acccept it. Best magnifying app. Perhaps the Tips app might be the place for Apple to showcase these kinds of features, but I find most users are not discovering them on their own. ![]() I can change that since I have admin permission on the remote box. Somebody help me. For Unix like systems the following solution worked for me to reset the root password: Jist: Recover MySQL database server password with following five easy steps: • Stop the MySQL server process. • Start the MySQL (mysqld) server/daemon process with the --skip-grant-tables option so that it will not prompt for password. • Connect to mysql server as the root user. • Setup new mysql root account password i.e. Reset mysql password. • Exit and restart the MySQL server. Specific commands: (login as the root user): • Stop mysql service # /etc/init.d/mysql stop Output: Stopping MySQL database server: mysqld. Apr 21, 2017 How to solve Access denied for user 'root'@'localhost' using password: YES or Access denied for user 'root'@'localhost' (using password: NO) or reseting the mysql password or how to solve forget. Norton antivirus phone number. • Start to MySQL server w/o password: use mysqld_safe: mysqld_safe --skip-grant-tables & Output: [1] 5988 Starting mysqld daemon with databases from /var/lib/mysql mysqld_safe[6025]: started • Connect to mysql server using mysql client: # mysql -u root Output: Welcome to the MySQL monitor. Commands end with; or g. Your MySQL connection id is 1 to server version: 4.1.15-Debian_1-log Type 'help;' or ' h' for help. Type ' c' to clear the buffer. Mysql> • Setup new MySQL root user password mysql> use mysql; mysql> update user set password=PASSWORD('NEW-ROOT-PASSWORD') where User='root'; mysql> flush privileges; mysql> quit • Stop MySQL Server: # /etc/init.d/mysql stop Output: Stopping MySQL database server: mysqld STOPPING server from pid file /var/run/mysqld/mysqld.pid mysqld_safe[6186]: ended [1]+ Done mysqld_safe --skip-grant-tables • Start MySQL server and test it: # /etc/init.d/mysql start # mysql -u root -p.
0 Комментарии
Оставить ответ. |
АвторНапишите что-нибудь о себе. Не надо ничего особенного, просто общие данные. Архивы
Март 2019
Категории |