1

My MySQL root user is gone, how do I recover it?

view story
linux-howto

http://serverfault.com – I was trying to move the MySQL tables so them were in another folder, so I messed out the plugins table or something like that and I ended up reinstalling the whole thing. I did sudo aptitude purge mysql-server then I removed the MySQL data rm -rf /var/lib/mysql/mysql and also I removed the data from the other directory I was trying to move the tables. After reinstallation I supposed I would be able to login using mysql -u root but it said the user was wrong. I tried with the old password and the same thing. Then I searched for a way to reset the root password. So I did mysqld_safe --skip-g (HowTos)

dayu's picture
Submitted by dayu on 08/22/2011

Stories similar to My MySQL root user is gone, how do I recover it?

I've been trying to reset the root password, and have been following these instructions: http://www.coolestguyplanet.net/how-to-change-the-mysql-root-password/

However, when I use the command:

/usr/local/mysql/bin/mysqld_safe --skip-grant-tables

I receive the following output:

111217 10:00:42 mysqld_safe Logging to '/usr/local/mysql/data/******-********-MacBook-Pro.local.err'. 111217 10:00:42

I have linux root password. There's MySQL server on that machine. One of the site's ini was rewritten and now it can't reach the mysql database. I don't have mysql root to change the password for database user. The server owner is now in vacation, so I can't ask him to give me the mysql root. I can reset mysql root password, but I don't want.

I need:

Save current mysql root password hash somewh

I really did it this time.. I deleted a database named MySQL in my server. Shortly after MySQL went haywire and now I cannot login as a user to mysql, I cannot re-install mysql, I get an error for every solution I try.

So I decided hell with it I'll remove mysql, php and start again. I used rpm -qa | grep mysql but it returned nothing.

I finally got a Raspberry Pi for Christmas and decided to set it up as a home web server. I have nginx with php setup and working. I came to install mysql and ran sudo apt-get install mysql-server.

I've changed data directory in /etc/my.cnf.

How to create tables in MySQL 2 years 24 weeks ago

Our Tuesday MySQL tip, how to create Tables in a MySQL Database. Tables are somehow like spreadsheets, and one database may have lots of tables into it. So, once you have created your Database you may create the tables inside the Database. We’ll do it, working on the command line: First connect to the MySQL mysql -u [user] -p

This will ask the password for the user [user], it should be the

Mysql server is installed on my quest OS Centos6 (192.168.1.50) and using port 3306. I'm trying to connect from my Windows OS (192.168.1.2).

I'm getting error #1045 Access denied for user 'root'@'192.168.1.2' (using password: YES) So, as far as I understand this error is telling me that I have no rights to access mysql using user root from 192.168.1.2 host.

So I'm running crunchbang linux and installed mysql-server using the following terminal command:

sudo apt-get install mysql-server

Setup runs without problems, but when trying to access mysql I get "Error 1045 Access denied". The tutorial I used stated that during setup of mysql-server I'd be asked to set a password, but this step never happened.

I think yum is having problems installing MySQL 5.1 because there is already a pre-existing MySQL 5.5 installation.

I wanted to cleanly remove MySQL 5.5 (I had problems with 5.5 with PHP and Python).