homepage Welcome to WebmasterWorld Guest from 54.205.122.62
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
basic understanding MYSQL troubles
I need help!
dr_paul

5+ Year Member



 
Msg#: 3603285 posted 8:22 pm on Mar 17, 2008 (gmt 0)

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]

 

gosman

10+ Year Member



 
Msg#: 3603285 posted 7:19 pm on Mar 18, 2008 (gmt 0)

Hi dr_paul.

I reccomend Navicat MySQL

dr_paul

5+ Year Member



 
Msg#: 3603285 posted 7:52 pm on Mar 18, 2008 (gmt 0)

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

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved