http://www.stat.ufl.edu http://www.stat.ufl.edu

Mysql on Ubuntu 7.10

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>


(C) University of Florida, Gainesville, FL 32611; (352) 392-1941.
This page was last updated Mon Sep 24 23:39:46 EDT 2012
http://www.ufl.edu