LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 09-15-2004, 03:19 AM   #1
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 939

Rep: Reputation: 32
mysql tutorial


Hi all

Can any one point me to a good tutorial that is step by step if possible please. for adding user, databases etc etc.

Using Mysql 3.23.58, Fedora Core 2

TT
 
Old 09-15-2004, 04:01 AM   #2
Boby
Member
 
Registered: Feb 2004
Location: Sighisoara/Cluj-Napoca (Romania)
Distribution: CentOS 4, Fedora Core 6
Posts: 781

Rep: Reputation: 32
Hello!

I thing the "MySQL Reference Manual" from http://dev.mysql.com/doc/ is very good! I learned everything from there.


Maybe you want to take a look at these too:

MySQL Cookbook
By Paul DuBois

MySQL Cookbook provides a unique problem-and-solution format that offers practical examples for everyday programming dilemmas. For every problem addressed in the book, there's a worked-out solution or "recipe"--short, focused pieces of code that you can insert directly into your applications. More than a collection of cut-and-paste code, this book explanation how and why the code works, so you can learn to adapt the techniques to similar situations.

MySQL Pocket Reference
By George Reese

Easy to take and use anywhere, the MySQL Pocket Reference provides instant reminders on how to use important MySQL functions in conjunction with key parts of the LAMP open source infrastructure. The book covers installation of MySQL and includes a description of SQL commands, data types, operators, and functions. In this small book, you get a handy reference to the enormous feature set of MySQL, the dominant database in the open source world.

Managing & Using MySQL, 2nd Edition
Open Source SQL Databases for Managing Information & Web Sites
By George Reese, Randy Jay Yarger, Tim King
With Hugh E. Williams

Learn how to use MySQL, a popular database product that supports key subsets of SQL on Linux and Unix systems. Using C/C++, Java, Perl, PHP, or Python, you can write programs to interact with a MySQL database, either as a stand-alone application or through a web page. This book covers the whole process, from installation to programming interfaces and database administration. It includes ample tutorial material and examples

Hope this helped!
Good luck!
Boby
 
Old 09-15-2004, 04:02 AM   #3
Mega Man X
LQ Guru
 
Registered: Apr 2003
Location: ~
Distribution: Ubuntu, FreeBSD, Solaris, DSL
Posts: 5,339

Rep: Reputation: 64
Something like these?

http://www.techtutorials.info/mysql.html

http://www.analysisandsolutions.com/code/mybasic.htm
 
Old 09-15-2004, 04:04 AM   #4
Mega Man X
LQ Guru
 
Registered: Apr 2003
Location: ~
Distribution: Ubuntu, FreeBSD, Solaris, DSL
Posts: 5,339

Rep: Reputation: 64
Wow, great post by Boby. Puts my on shame
 
Old 09-15-2004, 08:30 PM   #5
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 939

Original Poster
Rep: Reputation: 32
Thanks Guys

I have been working with mysql, trying to get the hang of it.

Using Linux guys, not windoze...

Here is what i have so far, i still cant conntect to mysql from my XP ( XP to Linux )

mysqladmin ping
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'


telnet mydomain.com 3306
Trying 202.xx.xxx.xxx
telnet: connect to address 202.xx.xxx.xxx: Connection refused

Yes MySQL is running

TT
 
Old 09-16-2004, 06:53 AM   #6
3spre10
LQ Newbie
 
Registered: Sep 2004
Distribution: SuSE
Posts: 21

Rep: Reputation: 15
Quote:
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
If mysql is running then you might changed the password somehow, OR, you have a firewall there that restricts access to port 3306...
 
Old 09-16-2004, 07:41 AM   #7
Boby
Member
 
Registered: Feb 2004
Location: Sighisoara/Cluj-Napoca (Romania)
Distribution: CentOS 4, Fedora Core 6
Posts: 781

Rep: Reputation: 32
Try this:
mysqladmin -u root -p ping

You have to enter mysql-root's password. Now it should return mysql is alive or at least I hope so.

Boby
 
Old 09-16-2004, 09:50 PM   #8
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 235Reputation: 235Reputation: 235
Have you actually grant privileges for you user or users to connect from another host?

Code:
GRANT ALL PRIVILEGES TO 'user@hostname' IDENTIFIED BY 'password';
That would give the user 'user' from 'hostname' with a password of 'password' to your Database.. etc.

I'd suggest reading the online book at www.mysql.com in the docs section like mentioned before, its quite helpful.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Tutorial for BIND with mySQL backend mrEgg Red Hat 3 12-14-2004 04:20 AM
Mysql Tutorial!!! baby_linu Linux - Newbie 3 03-07-2004 07:42 AM
MySQL tutorial Thinkgeekness Linux - Software 11 04-07-2003 10:00 PM
MySQL tutorial stuff tarballed Linux - General 4 02-14-2003 10:37 PM
Installation Tutorial Apache 2, PHP 4, MySQL 3.23 freddymio Programming 2 07-03-2002 10:40 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 07:19 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration