loading files onto MySQL
Newbie question here. Using Mac OSX Server 10.4.4. Do most MySQL tasks in terminal window. Recently purchased software that tells me to go to Control Panel (which I don't think I have--though I have MySQL tools) and load their file onto the MySQL database. I'm not sure what this means. If I create a database called test is there a way to load their file onto that database in the terminal window? Thanks. I'm probably asking a very stupid question. _ Type your favorite song. Get a customized station. Try MSN Radio powered by Pandora. http://radio.msn.com/?icid=T002MSN03A07001 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SQL syntax
Hi, I'm getting the following error message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' enabled = '1'' at line 3INSERT INTO clf_cities SET cityname = 'Santa Barbara', countryid = , enabled = '1' and can't quite figure out what it means. Any help is greatly appreciated. Thanks, Scott _ Experience the magic of the holidays. Talk to Santa on Messenger. http://clk.atdmt.com/MSN/go/msnnkwme008001msn/direct/01/?href=http://imagine-windowslive.com/minisites/santabot/default.aspx?locale=en-us -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Complete newbie (OSX Server - MySQL)
Complete newbie here. Purchased software for my OSX Server 10.4.8 to use with MySQL and PHP. I get an installation window that opens and asks for Host: (with a default of localhost). User: site Password: (the one the person who sold me the script provided). Database: site License key: (the one the person who sold me the script provided). I hit the save button and get the following: Warning: mysql_connect(): Access denied for user 'site'@'localhost' (using password: YES) in /Library/WebServer/Documents/!install/install.php on line 298 Could not connect to the Database Questions: 1. I don't know if I have to do anything to MySQL to add the User and Database or whether the scripts supposed to do it for me. 2. I don't know if I'm supposed to use localhost or greenheartworld.com, which was the domain that I supplied to him (but want to change). Any help is greatly appreciated. Thanks, Scott _ Get FREE Web site and company branded e-mail from Microsoft Office Live http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
stupid newbie question
At the command prompt, I'm supposed to type: mysql -h host -u user -p Does that mean that I type, for example: mysql -h localhost -u admin -p with localhost=host and admin=user? When I'm asked for the password, I hit return and it lets me in. But if I try to create a database, by using: GRANT ALL ON store.* TO [EMAIL PROTECTED]; I get an ERROR 1044: Access denied for user: '@localhost' to database 'store' Any help is appreciated. --Scott _ Concerned that messages may bounce because your Hotmail account is over limit? Get Hotmail Extra Storage! http://join.msn.com/?PAGE=features/es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]