On Thursday 26 January 2006 13:57, Tek Budda wrote:
> Ok...time for an update on my progress. I have the latest MySQL, PHP &
> CRM-CTT software installed. Through some trial an error I seem to have
> MySQL support enabled and the REGISTER_GLOBALS set.
>
> I can't seem to get a datbase created. It could have something to do
> with permissions as I am using a local machine for testing and their is
> basically only An administrator and user aqccount on the system. I know
> this likely goes without saying, but seeing as the end locale of this is
> going to be on a server, I would assume that MySQL & PHP are both Active
> Directory friendly...or is there something else I need to do.
As I understand things, you need to jump through some configuration hoops to
get Active Directory (aka LDAP) support. But you will not have it with a
fresh install of either. (Well, if you included LDAP support with PHP, then
you should be able to talk to an LDAP server....)
But it sounds like you are trying to set up LDAP authentication for MySQL.
When it comes to creating a database, this normally isn't the way. If you
have followed all the install instructions, you should have a "root" user
(different than the Linux root user, and may have a different name), that has
permission to do everything. If so, you would do a command something like
so:
mysql -u root -p
This will prompt you for the password of your MySQL root user (not the Linux
root user), and put you into the command shell for MySQL. From there you
would enter the command:
create database mydatabase
And this will create an initial database for you.
At this point, you probably have an SQL script to run that will create the
necessary tables. If so, exit the MySQL prompt (with the exit command, or
quit), and run the following:
mysql -u root -p mydatabase < /path/to/sql/script/file
IF your script file has the create database command in it, then ignore the
create command above, and run the command:
mysql -u root -p < /path/to/sql/script/file
At that point, your database should be created. If your script didn't create
a user account for accessing the database, you probably need to do this
manually like so:
mysql -u root -p MyDatabase
grant all privleges on MyDatabase.* to [EMAIL PROTECTED]
identified by 'password'
(the second command should be entered on one line)
Then when you set up PHP access to your database, you would use this user
account and the password you specified. You *can* set up multiple users with
permissions, but most web apps I've seen use a single database user, and
control access within the application itself (i.e. the database has a user
table of some sort). In your case though, I'd recommend to follow the method
specified by the CRM package you are using.
HTH
Shawn
_______________________________________________
clug-talk mailing list
[email protected]
http://clug.ca/mailman/listinfo/clug-talk_clug.ca
Mailing List Guidelines (http://clug.ca/ml_guidelines.php)
**Please remove these lines when replying
