LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices

Reply
 
Search this Thread
Old 07-02-2012, 04:30 PM   #1
Bob Fletcher
Member
 
Registered: Nov 2008
Location: Hinckley UK
Distribution: CentOS 6.4
Posts: 84

Rep: Reputation: 1
MySQL Setup problem


Can someone please help me get out of a mess. Under Ubuntu 11.10 I installed the LAMP package. Came up with the Apache welcome. I then installed Webmin all was well. Then disconnected the server box started it up and worked under Webmin.

Later I tried to log into MySQL and Webmin asked for my login. It would not accept it as root or robert.

This is where I stuffed things up. I edited the debian.cnf file replaceing the root login with my username and password. I later see that this file on it's header says DO NOT TOUCH.

I then read the LAMP instructions for setting up MySQL and as I was accessing from another machine I set the bind address of the server 192.168.16.

But nothing else I could do I was unable to set root password and there I am stuck.

How can I repair this? Perhaps if I have a new debian.cnf things way work.

Robert..
 
Old 07-02-2012, 04:41 PM   #2
Kustom42
Senior Member
 
Registered: Mar 2012
Distribution: Red Hat
Posts: 1,590

Rep: Reputation: 412Reputation: 412Reputation: 412Reputation: 412Reputation: 412
Slow down here a second... You need to roll back your debian.cnf. The root password for MySQL is completely different.

Follow these steps for resetting your MySQL root password:

dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
http://www.cyberciti.biz/tips/recove...-password.html
 
Old 07-02-2012, 05:10 PM   #3
Bob Fletcher
Member
 
Registered: Nov 2008
Location: Hinckley UK
Distribution: CentOS 6.4
Posts: 84

Original Poster
Rep: Reputation: 1
Quote:
Originally Posted by Kustom42 View Post
Slow down here a second... You need to roll back your debian.cnf. The root password for MySQL is completely different.

Follow these steps for resetting your MySQL root password:

dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
http://www.cyberciti.biz/tips/recove...-password.html
Thank you for your very quick reply unfortunately I am not getting far. I am trying to do thin under the Webmin command like.

> /etc/init.d/mysql stop
Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql stop

Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the stop(8) utility, e.g. stop mysql
> stop mysql
stop: Unknown instance:
 
Old 07-02-2012, 05:30 PM   #4
Bob Fletcher
Member
 
Registered: Nov 2008
Location: Hinckley UK
Distribution: CentOS 6.4
Posts: 84

Original Poster
Rep: Reputation: 1
Hi me again, it seems to be working now but I did not get the responses from what I was following. Anyway I have set a password in Webmin. Webmin just logs in to MySQL without and further login password request but as long as its working and safe I am happy.
Thanks a lot for all your help.
Robert...
 
Old 07-02-2012, 05:30 PM   #5
Kustom42
Senior Member
 
Registered: Mar 2012
Distribution: Red Hat
Posts: 1,590

Rep: Reputation: 412Reputation: 412Reputation: 412Reputation: 412Reputation: 412
The commands you are issuing are shell commands, are you able to establish an SSH or terminal connection to the server?

The "service" command refrenced is /sbin/service. Try /sbin/service mysqld status or start.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL setup without "mysql.server" in CentOS5 Ericxx Linux - Server 3 07-16-2010 03:51 AM
[SOLVED] Debian Etch, Wordpress+mysql: setup-mysql script = permission denied oznola Linux - Server 9 04-07-2010 09:08 PM
MySQL setup: I ran mysql_install_db ***without *** --user=mysql. slackmate Slackware 5 01-28-2010 06:54 PM
MySQL setup. sikofitt Programming 1 09-29-2005 05:43 AM
MySQL setup stops at command "./configure --prefix=/usr/local/mysql" k41184 Linux - Software 1 05-20-2004 03:44 PM


All times are GMT -5. The time now is 03:29 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration