Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Executing MYSQL code in my database


Medworks

Recommended Posts

Posted

I've been given the cryptic instructions to 'execute MYSQL code in my database' and then the words in parentheses

(Note: If you don't know how to do this then ask in the forums. Most anyone can explain it)

 

If it's so friggin' easy I'd rather I had been told how to do it directly but can anyone enlighten me? I tried going to all 4 choices under "databases" and doing whatever I could think of but I can never get to any place where I can "execute code". MySQL Database wizard looked the most promising, but all it seems to let me do is edit user information for the username that is allowed to sign into MySQL, I can't actually sign into it and I certainly can't execute any sort of code. Where do I go to "execute MYSQL code in my database"?

Posted
I've been given the cryptic instructions to 'execute MYSQL code in my database' and then the words in parentheses

(Note: If you don't know how to do this then ask in the forums. Most anyone can explain it)

 

If it's so friggin' easy I'd rather I had been told how to do it directly but can anyone enlighten me? I tried going to all 4 choices under "databases" and doing whatever I could think of but I can never get to any place where I can "execute code". MySQL Database wizard looked the most promising, but all it seems to let me do is edit user information for the username that is allowed to sign into MySQL, I can't actually sign into it and I certainly can't execute any sort of code. Where do I go to "execute MYSQL code in my database"?

Try using phpmyadmin in your webhosts control panel.

 

When you have logged into the control panel , you will have to find the databases section.

 

Click on the phpMyAdmin icon.

 

Select the user to configure database via phpMyAdmin and click on the Login icon.

 

A new window should open for phpMyAdmin.

 

In some cases, you may have to choose which database your OSC tables are located on. If this is the case, please choose the database from the list or the drop down box at the left.

 

To run a SQL query, click on "SQL" on the navigation bar (on the right side, click on the SQL tab at the top).

 

Then copy the code from the sql file and paste the code into the textarea on that page.

 

Click on the GO button and it is done.

 

If all goes well, your SQL query will now be succesfully entered.

Posted

Thanks! It worked.

 

Try using phpmyadmin in your webhosts control panel.

 

When you have logged into the control panel , you will have to find the databases section.

 

Click on the phpMyAdmin icon.

 

Select the user to configure database via phpMyAdmin and click on the Login icon.

 

A new window should open for phpMyAdmin.

 

In some cases, you may have to choose which database your OSC tables are located on. If this is the case, please choose the database from the list or the drop down box at the left.

 

To run a SQL query, click on "SQL" on the navigation bar (on the right side, click on the SQL tab at the top).

 

Then copy the code from the sql file and paste the code into the textarea on that page.

 

Click on the GO button and it is done.

 

If all goes well, your SQL query will now be succesfully entered.

Posted
Thanks! It worked.

See, it was easy (the second and third and.. time that you do it).

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...