LinuxQuestions.org
LinuxAnswers - the LQ Linux tutorial section.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 05-19-2007, 10:12 AM   #1
Enil8
Member
 
Registered: Jul 2003
Location: USA
Distribution: openSuSE 10.2, Ubuntu 6.06, Auditor
Posts: 72

Rep: Reputation: 15
MySQL setup openSuSE 10.2, no super user?


I setup MySQL previously before I updated to 10.2, so I just tried uninstalling and then reinstalling MySQL, but apparently something is messed up with user privileges. First of all, there isn't a root user, so I can't assign privileges to anyone else, which means I can no longer create any new databases. I've tried running mysql_install_db, but that doesn't do it. Can someone help me out so that I can either have a root account or give those privileges to a different account?

Thanks a lot in advance!
 
Old 05-20-2007, 02:30 PM   #2
Enil8
Member
 
Registered: Jul 2003
Location: USA
Distribution: openSuSE 10.2, Ubuntu 6.06, Auditor
Posts: 72

Original Poster
Rep: Reputation: 15
Or is it possible to somehow clear out the tables so that I can create new ones with mysql_install_db?
 
Old 05-25-2007, 09:03 AM   #3
johniccp
LQ Newbie
 
Registered: Nov 2003
Location: Broome County, NY
Distribution: SUSE 10 SP 2
Posts: 20

Rep: Reputation: 0
MySQL setup openSuSE 10.2

Hi.

How did you install MySQL? As root? Did you set up an additional user to start the mysql process or is mysql daemon started by root?
 
  


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
I can't run Firefox from my single user(only from a super user) nightrider Linux - Newbie 14 10-24-2006 08:35 PM
Running super user commands as normal user mickyg Linux - Security 5 10-14-2005 07:25 PM
OpenSuse apt-get upgrade SUPER craigevil Suse/Novell 6 08-27-2005 11:36 AM
MySQL user setup pembo13 Linux - Software 5 11-23-2003 10:00 PM


All times are GMT -5. The time now is 11:24 AM.

Main Menu
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