Instalacion de MySQL

Page last edited hace 939 días 13 horas
De Solaris-ES
Saltar a: navegación, buscar

Instalación de MySQL[editar]

Download: http://dev.mysql.com/downloads/mysql/#downloads
 # groupadd mysql
 # useradd -g mysql mysql  
 # pkgadd -d ./mysql-5.1.53-solaris10-x86_64.pkg 
 # cd /opt/mysql/mysql/scripts
 # mysql_install_db --datadir=/opt/mysql/mysql/data --basedir=/opt/mysql/mysql --user=mysql 
 # mysqld_safe 
 # mysql -u root
 mysql> update mysql.user set password=PASSWORD("XXXXXX") where User='root';
 mysql> GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY 'XXXXXX' WITH GRANT OPTION;
 mysql> flush privileges;
 mysql> quit
 # pkill -9 mysql

Privilegios de Grant para ROOT[editar]

 # /etc/init.d/mysql stop
 # mysqld_safe --skip-grant-tables &
 # mysql -u root
 > USE mysql;
 > UPDATE user SET Grant_priv = 'Y' WHERE user = 'root';
 > quit
 # /etc/init.d/mysql stop
 # /etc/init.d/mysql start