Howto / Mysql
How to install MYSQL from sources
Author: Katrame
Visits: 2373
Date: 17.04.2007
We need to set an administrator password
# ./bin/mysqladmin -u root password 'NEWPASSWORD'
We link the binary on the env path
# cd /usr/local/bin/
# ln -s /usr/local/mysql/bin/mysql mysql
And finally we can start to test all
# mysql -u root -p
mysql> CREATE DATABASE NEWDATABASE;
mysql> GRANT all ON NEWDATABASE.* TO NEWDATABASE@localhost IDENTIFIED BY 'NEWDBPASSWORD';
mysql> SET PASSWORD FOR 'NEWDATABASE'@'localhost' = OLD_PASSWORD('NEWDBPASSWORD');
######
###### For development purpose.
###### mysql> GRANT select, insert, update, delete ON NEWDATABASE.* TO NEWDATABASE@'%' IDENTIFIED BY 'NEWDBPASSWORD';
######
exit
Author: Katrame
Visits: 2373
Date: 17.04.2007
We need to set an administrator password
# ./bin/mysqladmin -u root password 'NEWPASSWORD'
We link the binary on the env path
# cd /usr/local/bin/
# ln -s /usr/local/mysql/bin/mysql mysql
And finally we can start to test all
# mysql -u root -p
mysql> CREATE DATABASE NEWDATABASE;
mysql> GRANT all ON NEWDATABASE.* TO NEWDATABASE@localhost IDENTIFIED BY 'NEWDBPASSWORD';
mysql> SET PASSWORD FOR 'NEWDATABASE'@'localhost' = OLD_PASSWORD('NEWDBPASSWORD');
OLD_PASSWORD('NEWDBPASSWORD')
This grant the back compatibility, for old style password management (old mysql version)
######
###### For development purpose.
###### mysql> GRANT select, insert, update, delete ON NEWDATABASE.* TO NEWDATABASE@'%' IDENTIFIED BY 'NEWDBPASSWORD';
######
exit
<<
Page 2 of 2
Se vuoi discutere con noi su questo articolo o comunque vuoi porci delle domande usa il nostro Forum
