Differences

This shows you the differences between two versions of the page.

@@ Line 1: / Line 1: @@
+=====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;
+<del>CREATE DATABASE spikestreamdb; </del>
+<del>GRANT CREATE,DROP,EVENT,SELECT,INSERT,UPDATE,DELETE ON spikestreamdb.* TO 'spikestream'@'%' ;</del>