New To Mysql

[queenpictoria]

Hello.

 

Man, I am so glad you're here. If you can't answer my question, at least it is a place to start.

 

I am adding links to my website, and one of my webmaster friends told me to go to Link Trader Pro and install it in order to monitor the reciprocal links on my website.

 

I went into the cPanel, and created a database.

I am not sure if it is done correctly.

 

1)

Three sections:

Databases:

Users:

Access Host:

 

I set up the database name: queenpi_Link Tracking

 

The next thing is Access Hosts:

I don't know what to do with that.

 

2)

Next I am supposed to create a new directory in my server: I'll call it "Links" when I create it.

 

I am not sure where to set up the new directory.

Do I put it in my public_html folder????

 

3)

Then I am to upload all files to this directory.

 

What files could that be?

I did download the Link Trader Pro program, is that what they mean by "all files"?

Or do I upload some other files?

 

4)

The next step is to CHMOD 777 the following files/folders:

install.pho

/admin/backups/

 

I guess by this time I'll know what there are.

 

5)

Next, I am to run the self-installation file

 

www.queenpictoria.com/Links/install.php.

 

6)

Fill in the database information and your link back url.

 

Link Back Url: This is the url you want your partners to link back to

Admin Username: Enter the Admin username of your choice

Admin Password: Enter the Admin password of your choice

Database Username: Your MYSQL database username

Database Password: Your MYSQL database password

Database Name: Your MYSQL database name

Database Host: Keep this as 'localhost'

 

7)

Log in to the admin panel using username & password.

 

www.queenpictoria.com/Links/admin/

 

8)

I'll be able to find my links homepage at:

 

www.queenpictoria.com/Links/php.index

 

9)

After installation delete install.php

 

Is this self-explanatory?

 

-----------------------------------

 

This is all new, and I don't know if this topic is outside the venue here.

I don't know what I am doing. I may have to mess it up first and then get

it right. That's usually how it happens for me.

 

I'll soak up any info you can provide.

 

I guess step 1 is a good place to start.

 

It is not a small thing, this website business.

I want to do it well. Thanks.

 

queenpictoria

[TCH-Bruce]

In cPanel add a database under the Database section. Just give it a name (do not enter spaces: linktracking)

 

Next create a user under Users. Use any name.

 

Next add the user to the database you created giving it permissions of "ALL".

 

You don't need to do anything in the access hosts section.

 

Create a folder in your public_html folder called "links" or what ever you want to call it.

 

Upload all the files in the archive to that folder. Change permissions on the files/folders it mentions to 777 using your FTP program or the File Manager in cPanel.

[queenpictoria]

In cPanel add a database under the Database section.  Just give it a name (do not enter spaces: linktracking)

 

Next create a user under Users. Use any name.

 

Next add the user to the database you created giving it permissions of "ALL".

 

You don't need to do anything in the access hosts section.

 

Create a folder in your public_html folder called "links" or what ever you want to call it.

 

Upload all the files in the archive to that folder.  Change permissions on the files/folders it mentions to 777 using your FTP program or the File Manager in cPanel.

<{POST_SNAPBACK}>

 

Hello Bruce.

 

I have done everything but the last step.

Do I upload all the links I have collected, or do I upload the Link Trader Pro software first?

 

I am assuming that I will automatically understand the changing of files/folders to 777 using the FTP program. I'll cross that bridge when I get there.

 

Thanks,

queenpictoria

[TCH-Thomas]

Hi April,

You will need to set the permissions first to finish the installation. After that you can fill your link manager with the links.

[queenpictoria]

Hi April,

You will need to set the permissions first to finish the installation. After that you can fill your link manager with the links.

<{POST_SNAPBACK}>

 

Hello Thomas,

 

I thought I did that when I set up the user and password.

What did I miss? Is there a primer I can read on this?

It doesn't look like rocket science.

 

Thanks for your reply,

 

April

[queenpictoria]

Hello Thomas,

 

I thought I did that when I set up the user and password.

What did I miss?  Is there a primer I can read on this?

It doesn't look like rocket science.

 

Thanks for your reply,

 

April

<{POST_SNAPBACK}>

 

 

Thomas,

 

Do you mean after I upload the software, I set permissions?

 

April

[TCH-Thomas]

Yes.

When you have followed Bruces instructions above you must chmod (set permission) for the folders/files as the instruction says. Usually you right click a file or folder in your ftp progam and choose properties and in there set it to the value the file/folder need.

[queenpictoria]

Yes.

When you have followed Bruces instructions above you must chmod (set permission) for the folders/files as the instruction says. Usually you right click a file or folder in your ftp progam and choose properties and in there set it to the value the file/folder need.

<{POST_SNAPBACK}>

 

Hi Again...

 

I have gotten as far as uploading the files and CHMODed

these folders/files/ to 777:

 

install.php

/admin/backups/

/lib/

 

Now I am running the self-installation file through the File Manager in my cPanel because my FTP will not open up the file for me.

 

I got to this screen:

 

 

Link Back Url: http://www.queenpictoria.com

Admin Username: queenpi

Admin Password: use password for entering TCH

Database Username: queenpic

Database Password: password used when setting up database

Database Name: LinkTracking

Database Host: localhost

 

Can you make sense out of this?

 

Warning: mysql_connect(): Access denied for user: 'queenpic@localhost' (Using password: YES) in /home/queenpi/public_html/LinkTracking/install.php on line 132

 

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/queenpi/public_html/LinkTracking/install.php on line 132

 

Perhaps I need to contact support.

What do you think? I've gotten this far..

 

 

Thanks,

queenpictoria

[TweezerMan]

You need to prepend your CPanel username plus a "_" to your database name and database user name:

>Database Username: queenpi_queenpic
Database Name: queenpi_LinkTracking

[TCH-Don]

The normal steps to create and use a database are:

 

 

Be sure that in MySql you

 

1 - created the database

2 - created a user

3 -added the user to the database (this is the step most often forgotten)

 

 

Then to connect to the database in a script use:

 

host: localhost

database: yourCpanelName_databaseName

user: yourCpanelName_databaseUser

password: mypassword

 

* Note password is just as the password,

do not add the CpanelName to it.

[queenpictoria]

You need to prepend your CPanel username plus a "_" to your database name and database user name:

>Database Username: queenpi_queenpic
Database Name: queenpi_LinkTracking

<{POST_SNAPBACK}>

 

Hi David,

 

Thanks for your reply.

I tried to look the word "prepend" up and could not find it.

It just seems important that I know what to do with my cPanel username in addition to adding "_" to the database name and database user name.

 

Probably just a typo. Do you mean "prepare"?

 

Thanks,

queenpictoria

[TCH-Don]

It means you have to add your cpanel name in front of the database and user names

like yourCpanelName_databaseName when using a database with a script.

The data bases are on a shared server

so the the only way for you to access your database on the server is to use your cpanel name with it.

See my above post.

[queenpictoria]

I have done all the instructions above, and get a list of items that say "suceeded"

which I would guess means I succeeded.

 

On these types of script installations, do I now need to go in and submit each link into the system or is that already done?

 

If it is already done, how do I monitor it?

 

This is the program I have installed in MySQL on my domain:

http://www.elitelinksnewsletter.com/linktraderpro/

 

These are the "simple instructions". They are a lot like what you

folks have told me to do. It is like a cliff-hanger...what do I do now?

http://www.elitelinksnewsletter.com/linktraderhelp.html

 

Please forgive is this is outside the scope of the forum.

I just don't know where to go with this.

I am outside my comfort zone.

 

Thanks,

queenpictoria

[queenpictoria]

I am having one of my webmaster coaches help me sort this out.

Thanks for listening.

 

queenpictoria