Latest LQ Deal: Linux Power User Bundle
Go Back > Forums > Linux Forums > Linux - Software
User Name
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.


  Search this Thread
Old 05-19-2007, 11:12 AM   #1
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, 03:30 PM   #2
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, 10:03 AM   #3
LQ Newbie
Registered: Nov 2003
Location: Broome County, NY
Distribution: SUSE 10 SP 2
Posts: 20

Rep: Reputation: 0
MySQL setup openSuSE 10.2


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?


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 09:35 PM
Running super user commands as normal user mickyg Linux - Security 5 10-14-2005 08:25 PM
OpenSuse apt-get upgrade SUPER craigevil SUSE / openSUSE 6 08-27-2005 12:36 PM
MySQL user setup pembo13 Linux - Software 5 11-23-2003 11:00 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 10:12 AM.

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