mysql_embedded
You are viewing an old version of this article. View
the current version here.
mysql_embedded
is a mysql client statically linked to libmysqld, the embedded server. Upon execution, an embedded MariaDB server is instantiated and you can execute statements just as you would using the normal mysql client, using the same options.
From MariaDB 10.4.6, mariadb-embedded
is a symlink to mysql_embedded
.
From MariaDB 10.5.2, mysql_embedded
is the symlink, and mariadb-embedded
the binary name.
Do not run mysql_embedded while MariaDB is running, as effectively it starts a new instance of the server.
Examples
sudo mysql_embedded -e 'select user, host, password from mysql.user where user="root"' +------+-----------+-------------------------------------------+ | user | host | password | +------+-----------+-------------------------------------------+ | root | localhost | *196BDEDE2AE4F84CA44C47D54D78478C7E2BD7B7 | | root | db1 | *196BDEDE2AE4F84CA44C47D54D78478C7E2BD7B7 | | root | 127.0.0.1 | *196BDEDE2AE4F84CA44C47D54D78478C7E2BD7B7 | | root | ::1 | *196BDEDE2AE4F84CA44C47D54D78478C7E2BD7B7 | +------+-----------+-------------------------------------------+
Sending options with --server-arg
:
sudo mysql_embedded --server-arg='--skip-innodb' --server-arg='--default-storage-engine=myisam' --server-arg='--log-error=/tmp/mysql.err' -e 'select user, host, password from mysql.user where user="root"' +------+-----------+-------------------------------------------+ | user | host | password | +------+-----------+-------------------------------------------+ | root | localhost | *196BDEDE2AE4F84CA44C47D54D78478C7E2BD7B7 | | root | db1 | *196BDEDE2AE4F84CA44C47D54D78478C7E2BD7B7 | | root | 127.0.0.1 | *196BDEDE2AE4F84CA44C47D54D78478C7E2BD7B7 | | root | ::1 | *196BDEDE2AE4F84CA44C47D54D78478C7E2BD7B7 | +------+-----------+-------------------------------------------+
See Also
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.