Hi guys,
i need help, i want to add mysql custom script on game server. i am new to tcadmin. i got a script
#!/bin/bash
dbname=${ThisService_UserName}_${ThisService_ServiceId}
user=${ThisUser_UserName}
password=${ThisUser_Password}
mysql -h localhost -u root -pYourPassword -e "CREATE USER '$user'@'%%'"
mysql -h localhost -u root -pYourPassword -e "SET PASSWORD FOR '$user'@'%%' = PASSWORD('$password')"
mysql -h localhost -u root -pYourPassword -e "GRANT USAGE ON * . * TO '$user'@'%%' IDENTIFIED BY '$password' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0"
mysql -h localhost -u root -pYourPassword -e "CREATE DATABASE IF NOT EXISTS $dbname"
mysql -h localhost -u root -pYourPassword -e "GRANT ALL PRIVILEGES ON $dbname . * TO '$user'@'%%'"
when i add this in custom script with custom icon event, when i open it, it show me a blank page
so i contacted support ticket, as they said
what script they meant ?
can someone give me that script ?
thnz for reading
sorry for my bad english