PDA

View Full Version : [ubuntu] need help, new to mysql



benh13
July 15th, 2009, 02:02 PM
i have installed lamp, and i am learning how to use apache and php, however, i have no idea about mysql, where to start etc. i installed mysql, how do i open it and create databases? any help would be good lol.
thanks

HermanAB
July 15th, 2009, 02:42 PM
You got to go to the mysql web site and start reading - that is unavoidable. However, if you just want to get going with the common commands, see this maybe: http://aeronetworks.ca/MySQL_Howto.html

wojox
July 15th, 2009, 02:47 PM
Open a terminal and type:


mysql

Here's another good link: http://www.w3schools.com/

druhboruch
July 15th, 2009, 02:48 PM
You may wish to install gui tools for mysql
mysqladmin and query browser.

I think it would make your learning a little bit easier...

Raymond Day
July 15th, 2009, 03:38 PM
I used Webmin and it's easy to make a Data base with and back them up and do a lot with your data base easy.

You go to it's web page on your server port 10000 it sets up on. so http://server:10000

After it installs it says what address near the end of the text.

On Ubuntu server it's very easy to install and use. Install just do "apt-get install webmin" on the command line.

-Raymond Day