Access Denied when using MySQL can I fix or is my host supose to fix
Problem: I get "Access Denied" when I'm trying to use MySQL. Relevant Error Message: Error: -2147418113 Description: Chili!ASP ADO control - build 3.6.0 SQLState: S1000 Native Error Code: 1045 [TCX][MyODBC]Access denied for user: 'webmaster@localhost' (Using password: YES) My website host said to contact Chili!soft, Chili!soft said: Solution: This is not an issue with Chili!Soft ASP, but rather a permissions issue on the database server. The following commands show you how to adjust security on the MySQL server. Step By Step Instructions: To assign privileges in MySQL, execute the following SQL statement using the MySQL client Code Selections: 'Give the user all privileges when connecting from localhost GRANT ALL PRIVILEGES ON *.* TO @localhost IDENTIFIED BY '' WITH GRANT OPTION; 'Give the user all privileges when connecting from any host GRANT ALL PRIVILEGES ON *.* TO @"%" IDENTIFIED BY ''WITH GRANT OPTION; Also my host said: All connections to the ODBC driver should be setup to localhost on the system. All that is needed is to change where you have dvox.com to localhost. Is this somthing I can fix, or is it something my host should fix? Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
not allowed to connect to this MySQL server
I don't know anything about MySQL, Ive just been trying(with no luck)to install a forum(Snitz forum from www.snitz.com) on my website. My website is Linux/MySQL/Chilisoft! I open my setup.asp in my browser like: www.dvox.com/forum/setup.asp I get the prompt to login. Once I login I get this: ADODB.Connection.1 error '80004005' SQLState: S1000 Native Error Code: 1130 [TCX][MyODBC]Host 'dvox.com' is not allowed to connect to this MySQL server /forum/setup_login.asp, line 58 Any info about what this means, and how to fix it is appreciated Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: error in your SQL syntax near 'order by 'Variable_name' ????
I don't know anything about MySQL, Ive just been trying(with no luck)to install a forum(Snitz forum from www.snitz.com) on my website. My website is Linux/MySQL/Chilisoft! Im running out of support my host hasn't gotten back with me, and Snitz support doesn't know. So I got to messing around with the control panel on my website and went to MySQL database. I clicked on: Show MySQL system variables. Then I could click on: Variable_name, or Value both give me this: MySQL said: You have an error in your SQL syntax near 'order by 'Value' ASC' at line 1 So I thought this might be what is keeping me from getting my forum started - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
error in your SQL syntax near 'order by 'Variable_name' ????
Hi, MySQL said: You have an error in your SQL syntax near 'order by 'Variable_name' ASC' at line 1 Any ideas as to what this means, and how to fix it? Thanks, Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php