LinuxQuestions.org
Review your favorite Linux distribution.
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 10-28-2003, 08:00 PM   #1
Robin01
Member
 
Registered: Aug 2003
Posts: 104

Rep: Reputation: 15
creating mysql database


hello everybody..

i'm trying to get php to workwith mysql...and having problem.

before i used php to access mysql i did the following to create a database...
mysql> create database egineer;
mysql> GRANT SELECT,INSERT,UPDATE,DELETE
ON egineer.*
TO egineer@localhost
IDENTIFIED BY 'mypass';

i have redhat9, php and mysql installed...

when i runn throught the above inst. i found on the net.. it creates a folder but nothing in the folder. so, i'm assuming thats why php isn't able to locate the databse causing the problem...
when i run this, i'm not getting any err msg either...

Should the above actually create a database that i should see?

what am i doing wrong...
 
Old 10-28-2003, 09:29 PM   #2
wdingus
Member
 
Registered: Aug 2001
Location: Kingsport, TN
Distribution: RHEL & FC
Posts: 267

Rep: Reputation: 30
Can you login via the console/text client with this user/pass combo?

# mysql -uengineer -pmypass

Chnages to the grant tables require reloading.. When MySQL starts up these tables are read from disk and cached in RAM. Changes require them to be re-cached.

# mysqladmin -uroot -ppassword reload

Or just stop/start the database...
 
  


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
creating a webform to populate a database Doug.Gentry Linux - General 3 01-25-2005 06:57 PM
creating man page database student04 Linux - General 4 01-03-2005 07:08 PM
Writing an app that uses a mysql database without installing mysql server? QtCoder Programming 4 08-09-2004 02:43 PM
creating database using awk RajaRC Linux - General 11 07-30-2004 05:33 AM
Creating an RPM database Null Linux - Software 6 03-20-2003 06:09 PM


All times are GMT -5. The time now is 04:08 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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration