手工创建 kamailio database tables

本文主要是介绍手工创建 kamailio database tables，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

有些场景可能需要手工创建 kamailio database table，可参考下面的命令序列：

use mysql

select user,host from user;

drop user 'kamailio'@'%';
flush privileges;

drop database kamailio;

create database kamailio;
create user 'kamailio'@'%' identified by 'password';

grant all on kamailio.* to 'kamailio'@'%';

mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/standard-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/acc-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/alias_db-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/auth_db-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/avpops-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/carrierroute-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/cpl-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/dialog-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/dialplan-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/dispatcher-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/domain-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/domainpolicy-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/drouting-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/group-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/htable-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/lcr-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/matrix-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/mohqueue-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/msilo-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/mtree-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/pdt-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/permissions-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/pipelimit-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/presence-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/purple-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/registrar-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/rls-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/rtpengine-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/rtpproxy-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/sca-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/secfilter-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/siptrace-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/speeddial-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/topos-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/uac-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/uid_auth_db-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/uid_avp_db-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/uid_domain-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/uid_gflags-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/uid_uri_db-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/uri_db-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/userblocklist-create.sql
mysql -h127.0.0.1 -uroot -p'password' kamailio < /usr/share/kamailio/mysql/usrloc-create.sql