Appunti di informatica

spikestream

sudo apt-get install mysql-server

password utente root mysql = mysql (banale…)

ps -el | grep mysql 

(deve restituire in output mysqld)

mysql -u root -p

SpikeServer viene eseguito sullo stesso server mysql? c'è un firewall?

CREATE USER 'spikestream'@'localhost' IDENTIFIED BY 'spikestream';

Si può sostituire localhost con '192.168.1.0/255.255.255.0'

GRANT ALL ON *.* TO 'spikestream'@'localhost';
FLUSH PRIVILEGES;
exit

mysql -u spikestream -p

SET PASSWORD FOR 'spikestream'@'localhost'=PASSWORD("spikestream")

CREATE DATABASE SpikeStreamNetwork;
CREATE DATABASE SpikeStreamArchive;
CREATE DATABASE SpikeStreamAnalysis;

CREATE DATABASE spikestreamdb; GRANT CREATE,DROP,EVENT,SELECT,INSERT,UPDATE,DELETE ON spikestreamdb.* TO 'spikestream'@'%' ;