LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   Running MySQL (https://www.linuxquestions.org/questions/linux-newbie-8/running-mysql-863821/)

yogeshwaran 02-19-2011 10:13 PM

Running MySQL
 
Can anyone tell me step by step on how to run mysql in ubuntu 10.10 ?
I have installed Mysql Administrator and MySql Query Browser using the package manager.Please help me out on how to proceed further.
Thanks in advance..

Aquarius_Girl 02-19-2011 11:14 PM

Hitting out Google with the following keywords
Quote:

YoLinux MySql
see the first link.

yogeshwaran 02-20-2011 02:43 AM

thanks for the reply. . but do i ned to install apache tomcat to use mysql

Nylex 02-20-2011 02:47 AM

Quote:

Originally Posted by yogeshwaran (Post 4264509)
thanks for the reply. . but do i ned to install apache tomcat to use mysql

No. MySQL is a database. You don't need to use it with web technologies and a quick look at the Wikipedia page suggests that Tomcat isn't specifically for databases..

Noway2 02-20-2011 06:47 AM

If you haven't yet, please look at the tutorial that Anisha referenced. To be honest, it is one of the best introductions to MySQL that I have seen and will really help you to both get started and understand what MySQL does.

As Nylex mention, it is a database which holds data in key,value pairs where unlike a simple hash table the keys can be complex and compound expressions. By itself, a database doesn't do a whole lot for you. In order to unlock the real power of a database it needs to be combined with other applications. When combined with web based applications it becomes a very effective tool and most web scripting languages, for example PHP contain large libraries of functions designed to interact with databases. The net effect is that one can create pages that work with information stored in the database and can provide dynamic, customized content using the information stored in the database. The most common type of database driven application would probably be an e-commerce store. Another example would be an application that stores the results of a process and provides a web site where users can view customized graphs of the process variables based on desired search parameters.

SQL is also a programming language by itself and one can interact with a SQL database using this (textual) language. Since many find this difficult, there are graphical applications, like myadmin which provide a graphical interface and these applications run on Apache

whk 02-20-2011 10:49 AM

How to start MySQL the first time.

See under Testing here:
https://help.ubuntu.com/community/MYSQL5FromSource
BTW, it's good to read all.

starting MySQL normally

sudo /etc/init.d/mysql start
ref:
https://help.ubuntu.com/community/MysqlPasswordReset

Enter and creating a database.
mysql -u root -p
https://help.ubuntu.com/community/MySQL~QuickStartGuide

more ref:
http://dev.mysql.com/doc/refman/5.5/en/index.html
http://dev.mysql.com/doc/refman/5.5/en/tutorial.html


All times are GMT -5. The time now is 10:09 AM.