mysql

By 11 de junio de 2007 Linux, Ubuntu No Comments

ubuntu_anime.jpgHola,

Me hubiera encantado traducir este mini how-to, pero lo creo suficientemente descriptivo para ponerlo en la lengua de Cervantes.

Esopero que sirva de ayuda, a mi me sirvió :)

Installing Mysql database in Ubuntu

#apt-get install mysql-server mysql-client libmysqlclient12-dev

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

#vim /etc/mysql/my.cnf

Find the line bind-address = 127.0.0.1 and comment it out

#bind-address = 127.0.0.1

You can check your configuration using the following command

#netstat -tap

Output Looks like below

tcp 0 0 *:mysql *:* LISTEN 4997/mysqld

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

#mysqladmin -u root password your-new-password

#mysqladmin -h [email protected] -u root -p password your-new-password

#/etc/init.d/mysql restart

If you are looking how to create database,tables and other things check here

If you are looking for webinterface administration or GUI tools for your mysql database check here

mysql> GRANT insert,select,update,delete,create,drop,alter ON cpd .* TO root@'%' IDENTIFIED BY 'cpd';

Leave a Reply

Your email address will not be published.