=====MySQL=====
[[neurali: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'@'%' ;