Author:
erics , March 16th, 2022
Had an old server, needed to get root.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
service mysql stop
~ OR ~
service mysqld stop
cd / etc / init . d ;
. / mysql < tab > start -- skip - grant - tables
mysql > update mysql . user set Password = PASSWORD ( 'secret' ) where user = 'root' ;
mysql > flush privileges ;
mysql > ^ D
service mysql stop
service mysql start
~ OR ~
service mysqld stop
service mysqld start
For MySQL 5.7: https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html For some other v5.7 nodes, I had admin access via a different user’s login, so all I needed was this:
ALTER USER 'root' @ 'localhost' IDENTIFIED BY 'secret' ;
ALTER USER 'root' @ '%' IDENTIFIED BY 'secret' ;
How-To's , Technology Tags: 5.5 , Flush , Grant , init.d , Lost , mysql , MySQL 5.5 , Password , privileges , recover , Recovery , Reset , root , service , Skip , skip-grant-tables , Tables , User No comments
Author:
erics , December 7th, 2017
START: Server version: 5.5.54-log MySQL Community Server (GPL) FINISH: Server version: 5.7.20-log MySQL Community Server (GPL)
mysql -- execute = "SET GLOBAL innodb_fast_shutdown=0;"
service mysqld stop
yum remove mysql mysql - *
yum install mysql57 - devel mysql57 - server mysql57 - test
service mysqld start
mysql_upgrade
service mysqld restart
If you do not restart MySQL server at the end, you will get this error:
ERROR 1682 ( HY000 ) : Native table 'performance_schema' . 'session_variables' has the wrong structure
Check and veify your my.cnf ssl entries if you see the following error in the /var/log/mysqld.log file at startup:
Failed to set up SSL because of the following SSL library error : SSL_CTX_set_default_verify_paths failed
How-To's , Technology Tags: 5.5 , 5.7 , AWS , AWS Linux , CentOS , howto , mysql , MySQL 5.5 , MySQL 5.7 , tips , upgrade No comments
Author:
erics , July 29th, 2011
rpm - Uvh http : //rpms.famillecollet.com/enterprise/remi-release-5.rpm
yum -- enablerepo = remi , remi - test install mysql mysql - server
chkconfig -- levels 235 mysqld on
service mysqld start
If you get this error: “Table ‘mysql.servers’ doesn’t exist”, do this:
CREATE TABLE `servers` (
`Server_name` char (64) NOT NULL ,
`Host ` char (64) NOT NULL ,
`Db` char (64) NOT NULL ,
`Username` char (64) NOT NULL ,
`Password ` char (64) NOT NULL ,
`Port ` int (4) DEFAULT NULL ,
`Socket ` char (64) DEFAULT NULL ,
`Wrapper` char (64) NOT NULL ,
`Owner ` char (64) NOT NULL ,
PRIMARY KEY (`Server_name`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8 COMMENT ='MySQL Foreign Servers table' ;
How-To's , Technology Tags: 5.5 , CentOS , howto , Install , mysql , MySQL 5.5 , mysqld , phpmyadmin , tips No comments
erics, March 16th, 2022 
Categories: How-To's, Technology 5.5, Flush, Grant, init.d, Lost, mysql, MySQL 5.5, Password, privileges, recover, Recovery, Reset, root, service, Skip, skip-grant-tables, Tables, User
| 
No comments 
