LinuxQuestions.org
Share your knowledge at the LQ Wiki.
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 07-15-2009, 10:30 AM   #1
cll975dll
LQ Newbie
 
Registered: Aug 2008
Location: Pune
Distribution: Red Hat
Posts: 11

Rep: Reputation: 1
Mysql installation and configuration


i m using fedora i686 and wants to use mysql on it.
But i dont know how to install it and make use of it, means how to conigure clients and servers etc. How to create tables on linux using mysql. How to install various gui tools> Please help. Any help will be appreciated.

Thanks in advance.
 
Old 07-15-2009, 10:37 AM   #2
Wim Sturkenboom
Senior Member
 
Registered: Jan 2005
Location: Roodepoort, South Africa
Distribution: Slackware 10.1/10.2/12, Ubuntu 12.04, Crunchbang Statler
Posts: 3,786

Rep: Reputation: 282Reputation: 282Reputation: 282
I'm quite sure that you can install from the repositories (yum ?)

You can start reading the mysql v5 reference manual.
 
Old 07-15-2009, 11:24 AM   #3
arashi256
Member
 
Registered: Jan 2008
Location: Brighton, UK
Distribution: Ubuntu 12.04 / CentOS 6.5
Posts: 394

Rep: Reputation: 61
You can install MySQL on Fedora by su'ing to root and typing:-

yum install MySQL-\*

This *should* install both the server and the client. After that has done, you can start the MySQL server (assuming it doesn't start automatically) with: -

/etc/rc.d/init.d/mysqld start

...and access the database with: -

mysql -u root

(Might want to set a password on the root account - Google on how to do this, but I believe the server install tells you how to do it as well)

To create a database with one simple table from the mysql client: -

CREATE DATABASE <name>;
USE <name>;

CREATE TABLE mytable (
myID UNSIGNED INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
data VARCHAR(255)
);

Insert some data into our simple table: -

INSERT INTO mytable(data) VALUES ('Hello World!');

And pull the data back out...

SELECT myID, data FROM mytable;

And see the table with-

SHOW TABLES;

...and also...

SHOW DATABASES;

Quit the client with 'exit'.

Google for MySQL tutorials if you want to know more. I don't use any GUI tools with MySQL myself, so I don't know any to recommend. Anyway, hope this helps.
 
Old 07-16-2009, 02:39 AM   #4
cll975dll
LQ Newbie
 
Registered: Aug 2008
Location: Pune
Distribution: Red Hat
Posts: 11

Original Poster
Rep: Reputation: 1
Problem solved

Thanx araahsi256, I m very much thankful to u for helping me coming out of this problem.
Thanks
Quote:
Originally Posted by arashi256 View Post
You can install MySQL on Fedora by su'ing to root and typing:-

yum install MySQL-\*

This *should* install both the server and the client. After that has done, you can start the MySQL server (assuming it doesn't start automatically) with: -

/etc/rc.d/init.d/mysqld start

...and access the database with: -

mysql -u root

(Might want to set a password on the root account - Google on how to do this, but I believe the server install tells you how to do it as well)

To create a database with one simple table from the mysql client: -

CREATE DATABASE <name>;
USE <name>;

CREATE TABLE mytable (
myID UNSIGNED INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
data VARCHAR(255)
);

Insert some data into our simple table: -

INSERT INTO mytable(data) VALUES ('Hello World!');

And pull the data back out...

SELECT myID, data FROM mytable;

And see the table with-

SHOW TABLES;

...and also...

SHOW DATABASES;

Quit the client with 'exit'.

Google for MySQL tutorials if you want to know more. I don't use any GUI tools with MySQL myself, so I don't know any to recommend. Anyway, hope this helps.
 
  


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
Mysql-server-5.0 installation failed during configuration Lokathor Debian 20 09-22-2008 02:55 PM
any one know MySql installation and configuration for local web server base HenryCaasi Linux - Newbie 6 09-17-2008 05:58 AM
mysql-installation: Not enough space in /var/lib/mysql/ linus123 Linux - Software 8 11-10-2006 03:19 PM
MySQL 3.23.58-14 installation prolem - mysql.sock not found lightcom Linux - Software 4 02-23-2005 01:46 AM
php4 mysql, installation, php-pages with mysql info stay empty dnla Linux - Software 2 03-14-2004 03:54 PM


All times are GMT -5. The time now is 11:03 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