From: Waldemar Kozaczuk <jwkozac...@gmail.com>
Committer: Waldemar Kozaczuk <jwkozac...@gmail.com>
Branch: master
Changed MySQL to use InnoDB and properly setup admin user
This patch change MySQL app build script to set storage type to InnoDB
instead
of MyISAM in order to support referential integrity and transactionality.
New version
uses more explicit way to setup user record so that in case new columns are
added to the
User table the insert still works. Both 'set table_type ..' and 'insert
into user ..'
statements were broken and prevented MySQL clients from connecting. Please
note that
the correct way to connect is to use ip address instead of localhost host
name:
mysql -u admin -posv -h 127.0.0.1 mysql
Relately it has been noted that the best performance is achieved when using
fairl new version of QEMU/KVM (>= 2.11).
Fixes cloudius-systems/osv#955
Signed-off-by: Waldemar Kozaczuk <jwkozac...@gmail.com>
---
diff --git a/mysql/GET b/mysql/GET
--- a/mysql/GET
+++ b/mysql/GET
@@ -31,8 +31,8 @@ cd usr
./scripts/mysql_install_db --force --basedir=./ --ldata=data
cat <<EOF | eval './bin/mysqld --bootstrap --skip-grant-tables
--basedir=./ --datadir=data --max_allowed_packet=8M --net_buffer_length=16K'
use mysql;
-set table_type=myisam;
-insert into user values('%', 'admin',
password('osv'), 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0);
+set default_storage_engine=InnoDB;
+insert into user(Host, User, Password, Select_priv, Insert_priv,
Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv,
Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv,
Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv,
Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv,
Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv,
Create_user_priv, Event_priv, Trigger_priv, Create_tablespace_priv)
values('%', 'admin',
password('osv'), 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
EOF
cd $BUILDDIR/sql
--
You received this message because you are subscribed to the Google Groups "OSv
Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to osv-dev+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.