homepage Welcome to WebmasterWorld Guest from 54.227.40.166
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
basic understanding MYSQL troubles
I need help!
dr_paul




msg:3603287
 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




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

Hi dr_paul.

I reccomend Navicat MySQL

dr_paul




msg:3604440
 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