sql
how to uninstall/remove MSDE 2000 instance
By hu - Posted on March 7th, 2008 Tagged:The difference of MSDE to other software is it can be installed on a computer many times, generating a number of installations instance.
uninstall it is easy, through the Start menu -> Control Panel -> Add Remove Programs -> Microsoft SQL Server Desktop Engine (coresponding instance)
select the corresponding MSDE2000 instance to uninstall.
Warning: after the MSDE2000 uninstall, all database belonging to the instance will not be able to continue to use, even if the re-installation of the instance. Please do a backup of database through MSDESQL data backup or maintenance tool in advance.
MySQL add remote root administration
By hu - Posted on March 7th, 2008 Tagged:edit /etc/mysql/my.cnf
sudo vi /etc/mysql/my.cnf;
comment row bind-address = 127.0.0.1
restart mysql server
sudo /etc/init.d/mysql restart
ok, now grand privileges
sudo mysql
GRANT ALL PRIVILEGES ON * . * TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;
now you should able to see new root user by
use mysql;
select host,
user from user;
it should be able to logon from other computer. anyway it has a secure concern.