Mysql on Ubuntu

Last changed: Sun Aug 12 03:42:37 EDT 2007

This document assumes you have just installed mysql on Ubuntu 7.04 (Feisty Fawn) and are wondering how to set initial permissions.

### For mysql 5.0.38-Ubuntu_0ubuntu1-log on Ubuntu 7.04

### 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';
^D
bb$ mysql -p stat1
Enter password: [newpwd]
mysql>

Last modified: [an error occurred while processing this directive]