How do you grant a user rights to a specific database in Mysql?
Assuming you know the mysql root user's password:
user# mysql -u root -p
mysql> grant select,insert,update,delete on foobar.* to 'foouser'@'localhost';
If you also need to add a user:
mysql> create user foobar;
http://www.rockfloat.com/board/post/?id=608
July 03, 2009 @09:16
(Replies: 0)
How do you backup/restore a Mysql database?
Assuming you know the mysql root user's password:
user# mysql -u root -p
mysql> show databases;
user# mysqldump -u foo -p > foo-backup.sql
user# mysql -u root -p
mysql> create database foo;
user# mysql -u root -p foo < foo-backup.sql
http://www.rockfloat.com/board/post/?id=607
July 03, 2009 @09:01
(Replies: 0)
How do you create a user in Mysql?
Assuming you know the mysql root user's password:
user# mysql -u root -p
mysql> CREATE USER 'user1'@'localhost' IDENTIFIED BY 'foobar';
mysql> GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO 'user1'@'localhost';
mysql> GRANT ALL ON *.* TO 'user1'@'
[...]
http://www.rockfloat.com/board/post/?id=606
July 03, 2009 @08:55
(Replies: 0)
How do you reset the root mysql password?
Try:
root# /etc/init.d/mysqld stop
root# /usr/bin/mysqld_safe --skip-grant-tables &
root# mysql -u root mysql
> update user set password=password('foobar') where user = 'root';
> flush privileges;
root# killall mysqld_safe
root# /etc/init.d/
[...]
http://www.rockfloat.com/board/post/?id=582
September 26, 2007 @20:52
(Replies: 0)
windows administration of mysql
If anyone needs to work on mysql from a windows machine... here is a link to a windows based client for mysql:
http://anse.de/mysqlfront/
John M.
http://www.rockfloat.com/board/post/?id=260
April 16, 2002 @18:07
(Replies: 0)
What is a good tool for mysql replication?
try this:
<a href="http://www.webyog.com">http://www.webyog.com</a>
John M.
http://www.rockfloat.com/board/post/?id=75
October 18, 2004 @22:04
(Replies: 0)
