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’

2008 11 27 admin Linux Comments (0)

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 , ,
2008 11 25 admin MySQL Comments (0)

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)

2008 11 24 admin MySQL Comments (0)

Replication under MySQL

mysql master slave replication

2008 11 23 admin MySQL Comments (0)