sql

how to uninstall/remove MSDE 2000 instance

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

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.

Syndicate content