3

Resetting root password for MySQL problems (Mac OS X Lion)

view full story
linux-howto

http://serverfault.com – 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 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data /usr/local/mysql/bin/mysqld_safe: line 107: /usr/local/mysql/data/********-********-MacBook-Pro.local.err: Permission deni (HowTos)

dayu's picture
Submitted by dayu on 12/17/2011 – Made popular on 12/17/2011

Stories similar to Resetting root password for MySQL problems (Mac OS X Lion)

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

MySQL Error 2 years 44 weeks ago

Hello , I'm new to slackware , so, sorry if my Question looks dumb :)

so I'm trying to get MySQL work , when i run

Code: root@ahmed:/home/ahmed# /etc/rc.d/rc.mysqld restart root@ahmed:/home/ahmed# 100717 00:36:28 mysqld_safe Logging to '/var/lib/mysql/ahmed.err'.

I'm confused, I have a server that is accessible to the public, but I've been 3 times I was in the locker mysql root password by someone else, who knows the password that's just me.

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

Installing Mysql.

You can download MySQL at http://www.mysql.org/ . Unzip it at the /usr/local/src/. # cd /usr/local/src # tar zxf mysql-5.1.x.tar.gz # cd mysql-5.1.x To support multilanguage, we set up it as utf8. Also, we set up /usr/local/mysql as a basic directory.

MySQL 5.5 on Ubuntu 10.10 used to work well until yesterday but today whenever I start MySQL using mysqld_safe as root user it shows

Starting mysqld daemon with databases from /var/lib/mysql

and then shows pid ended

I havent run any updates recently but I used the MySQL administrator to connect to a remote database but MySQL administrator was installed one month ago.

I then examined the error

Can't start MySQL 38 weeks 3 days ago

Hi,

I have install MySQL serve in Fedora 16 32 bi distro that I have on my pc, but I can't start MySQL from command line. Can you please help?

Mysql Installation 3 years 24 weeks ago

After a fresh installation of F12, I can't get mysql to run. The problem appears to be caused by no user or group 'mysql'. The error log says:

091203 20:33:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 091203 20:33:27 [ERROR] Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists!

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.