Tech Site & Blog Blog about technology & programming

MySQL Add User

The simplest way to add user to MySQL and grant privileges for specific database.

1. Open terminal and type "mysql -u root -p" to start MySQL client and use your root account to connect to database.

2. Type "create database my_database;" to create a database with name my_database.

3. Type:

GRANT ALL PRIVILEGES
ON my_database.*
TO 'my_user'@'localhost'
IDENTIFIED BY 'my_password'
WITH GRANT OPTION;

With this command you've created a user with name my_user and password my_password with all privileges on my_database.

Create ISO from DVD on Mac

How to create ISO image from DVD?

1. Insert CD/DVD into computer and open Terminal.app

2. Type "mount" (without quotes) to list mounted drives

3. Type "unmount /dev/disk1" to unmount DVD from Mac OS X Finder

4. Type "dd if=/dev/disk1 of=/path/to/file.iso bs=2048" to copy content from DVD to file (this may take a while, depending on size of CD/DVD)

That's it. You copied content of DVD to your computer successfully.

How to mount ISO image?

hdid /path/to/file.iso