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

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

Something like these?

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

http://www.analysisandsolutions.com/code/mybasic.htm

Wow, great post by Boby. Puts my on shame :(

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

If mysql is running then you might changed the password somehow, OR, you have a firewall there that restricts access to port 3306...

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

Have you actually grant privileges for you user or users to connect from another host?

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.