shelwriter Posted October 10, 2004 Share Posted October 10, 2004 Hey guys - Yup, it's me again. This time I'm trying to install Duncan Carver's Link Management Assistant. It's a REALLY COOL link management tool and it's free. I'll try to find the website and post it here for you guys. Right now, I've followed the instructions exactly - wow, I'm getting pretty good at this PHP stuff!! I created a database in MySQL called LMA and added a user with all priviledges. When I go to the install page: http://www.thecorpwriter.com/lma/install.php It asks for the MySQL database server. I've put my server #, I've put my URL, I've put my user name and nothing is working. Can you tell me what it is?? Also, I'm confused on what the MySQL username and password is. Do I create it there? Does it have to be different from the admin username and password? Thanks guys!!!! Shel Quote Link to comment Share on other sites More sharing options...
shelwriter Posted October 10, 2004 Author Share Posted October 10, 2004 Here's the link to Duncan's software - and it's FREE! http://www.onlinemarketingtoday.com/software/ Quote Link to comment Share on other sites More sharing options...
TCH-Rick Posted October 10, 2004 Share Posted October 10, 2004 Generally you should use localhost for the database server in your scripts. Quote Link to comment Share on other sites More sharing options...
shelwriter Posted October 10, 2004 Author Share Posted October 10, 2004 Hey Rick - I fotgot to tell you, I tried localhost too. I get this error: Error: Couldn't connect to the specified MySQL server Could it be because I could be using the wrong MySQL username and password? I dont' know what that is, I didn't create one for it. I'm assuming that as I'm adding the information to the install.php page that it is creating it for me. Also, I'm using "lma" as my database name. I am not adding anything to it. Should I be using "lma_database" or something?? It doesn't say to in the intall instructions. Any other ideas for the database server? Thanks! Shel Quote Link to comment Share on other sites More sharing options...
LisaJill Posted October 10, 2004 Share Posted October 10, 2004 You didn't create a database and database user? You'll need to do that. There aren't any "pre-made" databases with your account. When you do that - make sure you Add the user to the databae, it's a seperate step that a lot of people don't remember to do. =) Quote Link to comment Share on other sites More sharing options...
shelwriter Posted October 10, 2004 Author Share Posted October 10, 2004 Lisa - Thanks for reminding me of that. Yes, I did do it though! LOL The install instructions told me to. Otherwise I wouldn't have known. I named the new database "lma" and added a user with all access. Anything else you can think of? I'm searching their forums for advice on this, but everything I'm reading says this type of error has to be dealt with from my hosting company. (sigh) I'm sorry! Shel Quote Link to comment Share on other sites More sharing options...
LisaJill Posted October 10, 2004 Share Posted October 10, 2004 How did you reference the database? did you use cpanelname_ima? or just ima? The latter won't work. Same with the database user - it's cpanelname_yourdbname - not yourdbname. Does that help at all? Quote Link to comment Share on other sites More sharing options...
shelwriter Posted October 10, 2004 Author Share Posted October 10, 2004 Aha Lisa - - Let me try that. Thanks!!! I'll let ya' know. Shel Quote Link to comment Share on other sites More sharing options...
shelwriter Posted October 10, 2004 Author Share Posted October 10, 2004 Lisa - That didn't work. Got the same error as above. Anything else?? Quote Link to comment Share on other sites More sharing options...
LisaJill Posted October 10, 2004 Share Posted October 10, 2004 You did replace the variables I used, right? "cpanelname" with your cpanel name? When you go to mysql manager, do you see a bunch of database connection strings? Or something else? Quote Link to comment Share on other sites More sharing options...
shelwriter Posted October 10, 2004 Author Share Posted October 10, 2004 Yes, I replaced "cpanelname" with my own. Yes, there are strings. Connection Strings Perl $dbh = DBI->connect("DBI:mysql:thecorp_lma:localhost","thecorp_shelwrit","<PASSWORD HERE>"); PHP $dbh=mysql_connect ("localhost", "thecorp_shelwrit", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("thecorp_lma"); Does that help?? Is it okay that I posted it here? Lord, I'm lost! Quote Link to comment Share on other sites More sharing options...
TCH-Dick Posted October 10, 2004 Share Posted October 10, 2004 Shel, not to brag but I had no problems I uploaded everything and set the permissions created my DB and user and added the user I attached a pic of the install page to give you an example of how I setup mine. Also make sure you have no spaces at the end of your entries on this page and double check your permissions. If you still can't get it let me know and I'll try to help you thru it. Quote Link to comment Share on other sites More sharing options...
shelwriter Posted October 11, 2004 Author Share Posted October 11, 2004 Alright Dick! Naughty I need help then!!!! Help me, help me, help me!!!! Can we do an IM thing or something? Shel Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.