Welcome to WebmasterWorld Guest from 54.167.175.107

Forum Moderators: open

basic understanding MYSQL troubles

I need help!

   
8:22 pm on Mar 17, 2008 (gmt 0)

5+ Year Member



Hello.

I am very new to all of this and I'm trying to understand some basic concepts about MYSQL which seem to be getting in the way of me getting anywhere.

I have paid for hosting with a company. They're fine and they have cpanel which also has phpmyadmin

I have already set up a few domain names and blogs with wordpress etc and so there are now MySQL databases available for me to look at via phpMyAdmin.

Now I'm trying to build to build some new databases directly into MySQL via phpMYAdmin but having problems with 1045 errors and so on.

So a few basic questions I have:

1. Is phpMyAdmin the only way to deal with SQL databases? And - if not - what are the alternatives? What is best?

2. WHERE are my databases actually stored? Am I able to see them in the document/file tree on file manager in the cpanel?

3. If I try SQL queries in phpMyAdmin and I get 1045 error (access denied) - how do I know deal with that?

4.If I use the LOAD DATA INFILE query, does adding the word "LOCAL" refer to the laptop I'm using right now or does it mean the server where all my hosting happens?

5. Are there are any REALLY SIMPLE online walk-through tutorials for getting started on MYSQL that anyone knows of...?

I've got lots of other questions and Iwish I had someone here to show me what to do but I think I'll leave it at that just now. Any answers gratefully received....

[edited by: tedster at 5:39 am (utc) on Mar. 18, 2008]

7:19 pm on Mar 18, 2008 (gmt 0)

10+ Year Member



Hi dr_paul.

I reccomend Navicat MySQL

7:52 pm on Mar 18, 2008 (gmt 0)

5+ Year Member



Thanks. A quick look at navicat tells me its going to COST. Are there any free alternatives?
 

Featured Threads

Hot Threads This Week

Hot Threads This Month