![]() ![]() # Read the manual for more InnoDB related options. # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/. #binlog_ignore_db = include_database_name # note: if you are setting up a replication slave, see README.Debian about # The following can be used as easy to replay backup logs or for replication. #log_slow_queries = /var/log/mysql/mysql-slow.log # Here you can see queries with especially long duration # Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf. #general_log_file = /var/log/mysql/mysql.log # As of 5.1 you can enable the log at runtime! # Be aware that this log type is a performance killer. # Both location gets rotated by the cronjob. # This replaces the startup script and checks MyISAM tables if needed # localhost which is more compatible and is not less secure. # Instead of skip-networking the default is now to listen only on #transaction-isolation = READ-UNCOMMITTED # The following values assume you have at least 32M ram # Here is entries for some specific programs # Remember to edit /etc/mysql/debian.cnf when changing the socket location. # It has been reported that passwords should be enclosed with ticks/quotes # This will be passed to all mysql clients # -print-defaults to see which it would actually understand and use. # Run program with -help to get a list of available options and with # One can use all long options that the program supports. ![]() # - "~/.my.cnf" to set user-specific options. # - "/etc/mysql/my.cnf" to set global options, # The MySQL database server configuration file. # - Uncomment the lines below and put into file: my.cfg. Sudo mv /etc/mysql/my.cnf /etc/mysql/my.cnf.orig mysql -uroot -proot -e "CREATE TABLE nsor_values_warehouse (id int(11) NOT NULL AUTO_INCREMENT, orig_id int(11) NOT NULL, value varchar(128) DEFAULT NULL, raw_value varchar(128) DEFAULT NULL, timestamp datetime DEFAULT NULL, sensor_id int(11) DEFAULT NULL, PRIMARY KEY (id), KEY sensor_id (sensor_id) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 " ![]() Mysql -uroot -proot -e "GRANT FILE ON *.* TO " Mysql -uroot -proot -e "GRANT ALL PRIVILEGES ON testdb.* TO " Mysql -uroot -proot -e "create user identified by 'testuser' " Mysql -uroot -proot -e "create database testdb " Sudo apt-get -yes -force-yes install libmysqlclient-devĮcho "******* Create MySQL Databases and Users ******* " Sudo apt-get -yes -force-yes install python-mysqldb Sudo apt-get -yes -force-yes install mysql-client Sudo apt-get -yes -force-yes install mysql-server ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |