ssh-rsa CHAVESSH google-ssh {"userName":"root","expireOn":"2021-12-30T00:00:00+0000"}

Execute o comandos abaixo para gerar sua chave.

ssh-keygen -t rsa

# How to install LAMP + PHPMyAdmin on Ubuntu 18.04 LTS

apt update && apt upgrade -y && apt autoremove -y && apt autoclean

# Install apache
sudo apt install apache2

# Install PHP
sudo apt-get install php php-curl php-xml libapache2-mod-php php-mysql php-mbstring php-gettext

# Install MySql
sudo apt-get install mysql-server mysql-client

sudo mysql_secure_installation


sudo systemctl restart apache2

mysql -u root -p

# MySQL CLI

SELECT user,authentication_string,plugin,host FROM mysql.user;

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Rathen@2356V9865';

# Para renomear o usuario "root"
RENAME USER 'root'@'localhost' TO 'linux'@'localhost';

exit; 

# Install PHPMyAdmin

sudo apt-get install phpmyadmin

# Metodo 1

ln -sf /usr/share/phpmyadmin /var/www/html

# Metodo 2

nano /etc/apache2/apache2.conf

# adicione a seguinte linha:

Include /etc/phpmyadmin/apache.conf

# comando para remover diretorios
rm -rf folder1

Correção do erro phpmyadmin

nano /usr/share/phpmyadmin/libraries/plugin_interface.lib.php

if ($options != null && count($options) > 0) {

if ($options != null && count((array)$options) > 0) {

nano /usr/share/phpmyadmin/libraries/sql.lib.php

|| (count($analyzed_sql_results[‘select_expr’] == 1)
|| (count($analyzed_sql_results[‘select_expr’] == 1

Aumentar taxa de upload no phpmyadmin

nano /etc/php/7.2/apache2/php.ini

memory_limit = 1500M

post_max_size = 1500M

upload_max_filesize = 1500M

sudo systemctl restart apache2


# Copilar emulador no Ubuntu

apt install mysql-client git make gcc libmysqlclient-dev zlib1g-dev libpcre3-dev build-essential manpages-dev -y

git clone https://github.com/rathena/rathena.git ~/rAthena

# Updating Existing Code
# To pull the latest updates for rAthena you can do the following:

git pull

./configure --enable-packetver=YYYYMMDD -  20180621 for rathena
make clean && make server

chmod a+x login-server && chmod a+x char-server && chmod a+x map-server

# How to Start
# Use the following commands:

# To Start:

./athena-start start

# To Stop:

./athena-start stop

# To Restart:

./athena-start restart

# if u get error like this : -bash: ./athena-start: /bin/sh^M: bad interpreter

# just install dos2unix

apt-get install dos2unix
# then run :

dos2unix athena-start 
# now u will able to use ./athena-start start after chmod a+x athena-start

# char_conf.txt

userid: s1
passwd: p1
server_name: rAthenaptbr
wisp_server_name: rAthenaptbr

login_ip: 127.0.0.1
//login_port: 6900
char_ip: 127.0.0.1
//char_port: 6121

pincode_enabled: no

# inter_conf.txt

// MySQL Login server
login_server_ip: localhost
login_server_port: 3306
login_server_id: root
login_server_pw: Rathen@2356V9865
login_server_db: ragnarok
login_codepage:
login_case_sensitive: no

ipban_db_ip: localhost
ipban_db_port: 3306
ipban_db_id: root
ipban_db_pw: Rathen@2356V9865
ipban_db_db: ragnarok
ipban_codepage:

// MySQL Character server
char_server_ip: localhost
char_server_port: 3306
char_server_id: root
char_server_pw: Rathen@2356V9865
char_server_db: ragnarok

// MySQL Map Server
map_server_ip: localhost
map_server_port: 3306
map_server_id: root
map_server_pw: Rathen@2356V9865
map_server_db: ragnarok

// MySQL Log Database
log_db_ip: localhost
log_db_port: 3306
log_db_id: root
log_db_pw: Rathen@2356V9865
log_db_db: logs
log_codepage:
log_login_db: loginlog

# map_conf.txt

userid: s1
passwd: p1

char_ip: 127.0.0.1
//char_port: 6121
map_ip: 127.0.0.1
//map_port: 5121