Fedora Linux Support Community & Resources Center
  #1  
Old 8th August 2008, 12:44 AM
mdwfed Offline
Registered User
 
Join Date: Aug 2008
Posts: 4
MySQL permission problems

I believe I have Fedora Core 6 and I know mysql 5.03. I have started the mysql server and I am trying to install openconf. I have permission problems creating a database. Something about ''@'localhost' and permissions. This happens even when I su to "mysql" user or try to use the --user parameter. Any ideas how to fix the problems? the mysql directors seem to be properly installed with mysql user.
Reply With Quote
  #2  
Old 9th August 2008, 05:47 AM
savage Offline
Registered User
 
Join Date: Jun 2005
Location: Mission Control
Posts: 1,229
Have a read through this and this.
Reply With Quote
  #3  
Old 10th August 2008, 11:43 PM
mdwfed Offline
Registered User
 
Join Date: Aug 2008
Posts: 4
Quote:
Originally Posted by savage
Have a read through this and this.
I've done that now, but now turning PHP error messages on, the mysql functions aren't being recognized. Somehow I'm thinking it is easier to install the software from scratch then to use the pre-installed Fedora stuff....

Is there a way to get PHP to recognize mysql functions without reinstalling???

This is the PHP error:
Call to undefined function mysql_connect() in /usr/local/www/cpsc/openconf/openconf/chair/install-db.php on line 24


Mary

Last edited by mdwfed; 10th August 2008 at 11:45 PM.
Reply With Quote
  #4  
Old 11th August 2008, 12:39 AM
savage Offline
Registered User
 
Join Date: Jun 2005
Location: Mission Control
Posts: 1,229
Try:
Code:
yum install php-mysql
Reply With Quote
  #5  
Old 11th August 2008, 02:14 PM
mdwfed Offline
Registered User
 
Join Date: Aug 2008
Posts: 4
I am working on that now. Will the database user be the user who owns that set of web site files or the user for apache?

Mary
Reply With Quote
  #6  
Old 11th August 2008, 02:43 PM
markkuk Offline
Registered User
 
Join Date: Apr 2005
Location: Finland
Posts: 5,075
MySQL has its own account management system that has nothing to do with Linux user accounts. Your database user isn't any Linux user, even if the MySQL username happens to be the same as some Linux username.
Reply With Quote
  #7  
Old 12th August 2008, 12:37 AM
savage Offline
Registered User
 
Join Date: Jun 2005
Location: Mission Control
Posts: 1,229
As markkuk said, MySQL and system users are completely separate, see the links above for how to create a new user for your PHP application.

I wouldn't recommend using the root user incase your app has any vulnerabilities, create a restricted user that only has access to the databases/tables that it needs.

If your not comfortable using the mysql command line, have a look for "MySQL Administrator" and "MySQL Query Browser" on the mysql site. Not sure if they're available on Linux (I'd guess at yes), but they provide a nice click-through GUI to setup users and databases/tables.

Edit: See here to download them

Last edited by savage; 12th August 2008 at 09:02 AM.
Reply With Quote
  #8  
Old 12th August 2008, 06:19 PM
mdwfed Offline
Registered User
 
Join Date: Aug 2008
Posts: 4
Quote:
Originally Posted by savage
As markkuk said, MySQL and system users are completely separate, see the links above for how to create a new user for your PHP application.

I wouldn't recommend using the root user incase your app has any vulnerabilities, create a restricted user that only has access to the databases/tables that it needs.

If your not comfortable using the mysql command line, have a look for "MySQL Administrator" and "MySQL Query Browser" on the mysql site. Not sure if they're available on Linux (I'd guess at yes), but they provide a nice click-through GUI to setup users and databases/tables.

Edit: See here to download them
Command line is fine, but my first attempt to create another user and use it failed. But then maybe I typed something wrong. Root does access the database now though. Thanks.

Mary
Reply With Quote
Reply

Tags
mysql, permission, problems

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
F8 NFS permission problems ajamison Servers & Networking 10 28th April 2008 08:02 AM
Permission problems PorPorMe Installation, Upgrades and Live Media 2 4th February 2008 08:48 PM
noob: Calling linux GURUs, folder file permission for mysql data directory gold Using Fedora 1 19th November 2007 03:34 PM
NFS Permission problems ALiAs Servers & Networking 0 29th December 2006 02:02 PM
permission problems. brethrap Using Fedora 3 29th March 2006 02:03 AM


Current GMT-time: 00:51 (Sunday, 20-04-2014)

TopSubscribe to XML RSS for all Threads in all ForumsFedoraForumDotOrg Archive
logo

All trademarks, and forum posts in this site are property of their respective owner(s).
FedoraForum.org is privately owned and is not directly sponsored by the Fedora Project or Red Hat, Inc.

Privacy Policy | Term of Use | Posting Guidelines | Archive | Contact Us | Founding Members

Powered by vBulletin® Copyright ©2000 - 2012, vBulletin Solutions, Inc.

FedoraForum is Powered by RedHat