Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

basic understanding MYSQL troubles

I need help!

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

Junior Member

5+ Year Member

joined:Nov 7, 2007
posts: 46
votes: 0


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)

Preferred Member

10+ Year Member

joined:Sept 7, 2003
votes: 0

Hi dr_paul.

I reccomend Navicat MySQL

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

Junior Member

5+ Year Member

joined:Nov 7, 2007
posts: 46
votes: 0

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

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members