Skip to content

{ Monthly Archives } November 2008

ssh without password

you can use this command in the shell cat ~/.ssh/*.pub | ssh user@remotehost ‘cat>>.ssh/authorized_keys’

How to create new user in MySQL

% = wildcard (any) Create a new Super-User “GURU” GRANT ALL PRIVILEGES ON *.* TO ‘GURU’@’%’ IDENTIFIED BY ‘abc123’ WITH GRANT OPTION; (root@localhost) [mysql]> select user,host,password from user; +———+———–+——————————– | user    | host      | password                                  | +———+———–+———————————- | root    | localhost | *6691484EA6B50DDDE1926A220 | | root    | suse01    | *6691484EA6B50DDDE1926A22| | replica | %         | […]

Tagged , ,

How to insert the dump file into the database?

uncompressed  dump file “file.sql”  into the example database mysql -u root -p example < /home/mysql/file.sql or for a small files mysql> use example database; mysql> source file.sql (file.sql must be  exist in the current directory)

Replication under MySQL

mysql master slave replication