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>
---
mysql/GET | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/mysql/GET b/mysql/GET
index 2e3d673..788f86e 100755
--- 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
--
2.17.0
--
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.
