{"id":230,"date":"2010-01-31T00:40:10","date_gmt":"2010-01-30T22:40:10","guid":{"rendered":"http:\/\/www.mythryll.com\/?p=230"},"modified":"2010-01-31T00:40:10","modified_gmt":"2010-01-30T22:40:10","slug":"howto-install-mysql-database-server-with-phpmyadmin-frontend","status":"publish","type":"post","link":"https:\/\/www.mythryll.com\/?p=230","title":{"rendered":"Howto Install Mysql Database Server with Phpmyadmin Frontend"},"content":{"rendered":"

I took this from here http:\/\/www.ubuntugeek.com\/howto-install-mysql-database-server-with-phpmyadmin-frontend.html <\/a><\/p>\n

MySQL\"\"<\/a> is a widely used and fast SQL database server. It is a client\/server implementation that consists of a server daemon (mysqld) and many different client programs\/libraries.<\/p>\n

Installing Mysql database in Ubuntu<\/strong><\/p>\n

sudo aptitude install mysql-server mysql-client libmysqlclient15-dev<\/code><\/p>\n

This will complete the installation of mysql server 5.0.45 in ubuntu gutsy.
\n
\nConfiguring Mysql in ubuntu<\/strong><\/p>\n

MySQL initially only allows connections from the localhost (127.0.0.1). We\u2019ll need to remove that restriction if you wish to make it accessible to everyone on the internet. Open the file \/etc\/mysql\/my.cnf<\/p>\n

sudo gedit \/etc\/mysql\/my.cnf<\/code><\/p>\n

Find the line bind-address = 127.0.0.1 and comment it out
\n\u2026
\n#bind-address = 127.0.0.1<\/code>
\n\u2026<\/p>\n

You can check your configuration using the following command<\/p>\n

#netstat -tap<\/code><\/p>\n

Output Looks like below<\/p>\n

tcp 0 0 *:mysql *:* LISTEN 4997\/mysqld<\/code><\/p>\n

MySQL comes with no root password as default. This is a huge security risk. You\u2019ll need to set one. So that the local computer gets root access as well, you\u2019ll need to set a password for that too. The local-machine-name is the name of the computer you\u2019re working on. For more information see here<\/p>\n

sudo mysqladmin -u root password your-new-password<\/p>\n

sudo mysqladmin -h root@local-machine-name -u root -p password your-new-password<\/p>\n

sudo \/etc\/init.d\/mysql restart<\/code><\/p>\n

Manage Mysql using Phpmyadmin<\/strong><\/p>\n

phpMyAdmin is a tool written in PHP\"\"<\/a> intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create\/drop\/alter tables, delete\/edit\/add fields, execute any SQL statement, manage keys on fields, manage privileges,export data into various formats and is available in 54 languages. GPL License information.<\/p>\n

Install phpmyadmin in ubuntu<\/strong><\/p>\n

sudo aptitude install phpmyadmin<\/code><\/p>\n

This will complete the installation.<\/p>\n

Now you need to goto http:\/\/serverip\/phpmyadmin\/<\/p>\n

Login using your mysql root as username and password<\/p>\n","protected":false},"excerpt":{"rendered":"

I took this from here http:\/\/www.ubuntugeek.com\/howto-install-mysql-database-server-with-phpmyadmin-frontend.html MySQL is a widely used and fast SQL database server. It is a client\/server implementation that consists of a server daemon (mysqld) and many different client programs\/libraries. Installing Mysql database in Ubuntu sudo aptitude install mysql-server mysql-client libmysqlclient15-dev This will complete the installation of mysql server 5.0.45 in ubuntu…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[],"class_list":["post-230","post","type-post","status-publish","format-standard","hentry","category-it"],"_links":{"self":[{"href":"https:\/\/www.mythryll.com\/index.php?rest_route=\/wp\/v2\/posts\/230","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mythryll.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mythryll.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mythryll.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mythryll.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=230"}],"version-history":[{"count":1,"href":"https:\/\/www.mythryll.com\/index.php?rest_route=\/wp\/v2\/posts\/230\/revisions"}],"predecessor-version":[{"id":231,"href":"https:\/\/www.mythryll.com\/index.php?rest_route=\/wp\/v2\/posts\/230\/revisions\/231"}],"wp:attachment":[{"href":"https:\/\/www.mythryll.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=230"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mythryll.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=230"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mythryll.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=230"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}