search

jeff1evesque / raspberry-pi

Raspberry Pi connects ZigBee wireless devices to an apache server.
6 stars 1 forks source link

Create new MySQL user #23

Closed jeff1evesque closed 9 years ago

jeff1evesque commented 9 years ago

We need to login to the Raspberry Pi, and create a new user:

$ mysql -u root -p
mysql> CREATE USER 'admin'@'localhost' IDENTIFIED BY '[USER_PASSWORD]';
mysql> GRANT CREATE, DELETE, DROP, EXECUTE, SELECT, SHOW DATABASES ON *.* TO 'admin'@'localhost';
mysql> FLUSH PRIVILEGES;

This will be the user / password we use to define various database related task on the raspberry pi. This will ensure a clear separation between root, and our new user admin.

jeff1evesque commented 9 years ago

This issue has been resolved, and documented in a wiki page for this repository.