I am VERY new to MySQL. It has been about 6-7 years since I built my last website, and I have to say things were a lot less complicated then. I am attempting to make a member site. I have MySQL 6.0, hosting thru MadDog. I got the aMember files uploaded to the site fine with the FTP, went into aMember setup, get this error: aMember Setup: Step 3 of 4 Cannot connect to mysql (Client does not support authentication protocol requested by server; consider upgrading MySQL client) Please return and fix these errors. Now, as far as I know I am running the newest version on MySQL. The database on the host is running 5.0. MySQL Database Information Status:Setup Host Name50mysql51.secureserver.net Database Name:adinrob Database Version:5.0 Description:aMember User Name:******* DSN:mysql_adinrob.dsn I have attempted to use the host's "troubleshooter" which does not have anything even remotely applicable. I am at a complete loss. Please keep in mind for any replies that I had to look up what PHP is on wiki... )
That makes two of us with the same question/issue. The Wiki "user manual" doesn't seem to cover the topic of setting up a mySQL database on the Web host. The user manual implies that there is a database that stores member data but it doesn't directly address the subject. For those of us who aren't professional database administrators/developers, it's an uphill battle. For example, I assume both a database and one or more tables within the database must be setup. But how many tables? Are there any rules, constraints, variable, etc. that one needs to setup? Then, how does the aMember software know the table names? Adinrob and I would appreciate anyone's help...
Ok, I don't feel completely inept alone then. The "users manual" is the most useless waste of internet space I have ever come across, and after a thorough scouring of this forum and the MySQL forums I have not found a definitve solution to what seems to be a very common problem. I know absolutly nothing about PHP, but from what I have read in the forums this error is a conflict in the PHP. As to what that means and how to fix it, no clue. Any help would be appreciated...
Well, progress has been made. I am no longer getting the first error, have an all new one Cannot select database 'aMember' (Access denied for user 'blurb0'@'localhost' to database 'aMember'). WTH? The only other thread I saw with the same issue never got any responses, and has been sitting since July. I can't wait that long. PLEASE help me. I will metaphorically kiss your feet, bless your firstborn, etc. I am beyond frustrated and would like to throw things, and only you can keep me from commiting cpu homicide...
Access the control panel for where you host your site and find the section on 'mysql database'. This is part of your web hosting package NOTHING to do with aMember. You need to select this and then actually add a database using a name such as aMember (or whatever) you should then receive a message saying database has been added. Do not add any tables. You now need to add a user for this database. IMPORTANT write down the database name, password and full database name as you will need to enter these into aMember. Now setup aMember, cannot remember the full process as it is now some time since I did it, and you will at some point be asked to enter these details. Note all is case sensitive. aMember will now construct the table structure within your database. Continue set up and you are well on your way.