help with mySQL!
 

ok, i am trying to get this webcalendar thing to work, and i have to setup mysql, php and apache. here is what i have apache is good, php is good and running with apache. But i cannot figure out the sql part her is the instruction... i have no idea what i am doing so be kind...



The following will create a database named "intranet".

mysqladmin create intranet

Next, create the database user account that will be used to access the database.

mysql --user=root mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO webcalendar@localhost
IDENTIFIED BY 'webcal01' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> QUIT

If you will be accessing MySQL from a different machine than the one running the web server, repeat the command above and replace 'localhost' with the hostname of the other machine.

Create the calendar tables using the supplied tables-mysql.sql file:

mysql intranet < tables-mysql.sql

In the above example, "intranet" is the name of your database.


Ok, so i am doing this in windows xp not linux as instructions seem to think but none of the commands seem to work, i just get a syntax error.
Now i was able to use different commands to get some of the stuff done, like to create the database i used.. "create database intranet"
And i think the mysql intranet < tables-mysql.sql command worked, because if i enter it again i get all these errors about how it is already created.

So when i try to go ahead with the instructions and configure the software to match the database it can't find the database...

http://i35.photobucket.com/albums/d1...runner/pic.jpg

If anybody knows what i am really doing (or not doing) in SQL (or should be doing) please let me know i am so lost :think:

If you would like to look at the software and try to figure out how it is to be done check it out HERE

I am really tired right know, and even though I am usually able to help with these errors (mainly because I have been through a lot), I have a total brain fart.

But here is my pathetic try... is the "Database Type" supposed to be "OBDC" and not mySQL? What are the other choices?

From the error, it looks like the webserver doesn't have the ODBC driver for that database installed.

Is this webcalendar thing a app you downloaded then tried to install? The screenshot is not an interface I'm used to.

yea, is this supposed to be webbased or on your computer? i bet youre just missing a driver.

that interface is typical of mysql... oversimplified. i hate it, i used it to make the board on NE4ROC and it is so crappy.

i wish i couldve just directly used sql.

do you have access to a mysqladmin interface? you can write straight SQL there... kind of command line-ish.

well luckily i didnt need it for more than creating a database and an admin user. the board script took care of the rest.

but thanks for the heads up, i never did see that.

um lets see that is the only thing on the drop down menu, i am entering the commands at the command prompt supplyed by sql, i didn't really have to install the program it is just a bunch of php and some sql files and all i really have to do is find a way to connect everything and host it. webcalendar is set up to use many database applications, i just already had mysql and that one was the recomended. There are actully a lot of people on here who know alot about SQL, thanks for the help.

is apache setup to run mysql? it might just be a matter of adding a line to you http.conf file.

This is what i was thinking. I had to edit http.conf for php to work, what do i need to do to get mysql to play with apache?

I don't remember off the top of my head, and now that I'm at home, I can't easily check the .conf file on my server at work. Google will give you the answers pretty quickly I would think, or you can just wait till I get to work in the morning.

If you don't see a reply from me in the AM, bump this thread as a reminder.

ok, i checked google alot and found lots of info about editing the .conf file to configure PHP, but nothing about editing for SQL. The program also has instructions for useing phpmyadmin instead of SQL, which i guess is just a fancy way to use SQL. But when i try to run phpmyadmin i get ...

phpMyAdmin - Error
Cannot load mysql extension. Please check your PHP configuration. - Documentation

So i guess something is not right here also, i found that you have to configure phpMyAdmin also, but configureation refers the the config.inc.php file for editing and i simply do not have this file, so what now?

You're right... you shouldn't have to configure your .conf file for MySQL (I couldn't remember for sure last night or not). When you installed MySQL, did you pick all the default settings? Did you get any error messages?

If you run phpinfo.php and check your settings, is there a MySQL section?

ok, well i finally gave up and got phpMyAdmin to work and was able to configure it that way. So it's all good, and it only took my about 18 hours to figure this out.

Yeah, database type is definitely not odbc. You need to use the native MySQL database connectivity if it is offered. YOu don't want to use odbc, period.

Apache and mysql have nothing to do with each other unless you're using mod_auth_mysql. PHP is what is actually making the connection to the mysql server. know I"m a little late on this, but I thought I'd throw this in. This is what I do on a daily basis. (PHP/MySQL development)

no. mysql doesnt need apache.

php needs apache to properly serve up php pages.

mysql can be called by either apache (in case of MOD_MYSQL for authenticantion needs) and by php... of course...