Mysql on Ubuntu 7.10

Last changed: Tue Dec 4 14:11:11 EST 2007

This document assumes you have just installed mysql on Ubuntu 7.10 (Gutsy Gibbon) and are wondering how to set initial permissions.

### For mysql-server-5.0 (5.0.45-1ubuntu3) on Ubuntu 7.10

### don't need "skip-networking" in /etc/mysql/my.cnf, now listens to localhost
#
### doesn't seem to change default
### # If you want transactions
### root# echo default-storage-engine=InnoDB >> /etc/mysql/my.cnf
root# /etc/init.d/mysql start
root# mysql -u root mysql
mysql> update mysql.user set password = password('newpwd') where user = 'root';
mysql> flush privileges;
^D
root# mysql -u root -p mysql
Enter password: [newpwd]
mysql> create database stat1;
mysql> create user 'bb' identified by 'newpwd';
mysql> grant
ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES,
CREATE VIEW, DELETE, DROP, EXECUTE, FILE, INDEX, INSERT, LOCK TABLES,
PROCESS, SELECT, SHOW DATABASES, SHOW VIEW, SHUTDOWN, UPDATE
on *.* to 'bb';
mysql> create user 'hostgen' identified by 'newpwd';
mysql> grant SELECT on *.* to 'hostgen';
^D
root# rm ~/.mysql_history

bb$ mysql -p stat1
Enter password: [newpwd]
mysql>

Last modified: Fri Sep 19 14:50:34 EDT 2008