(LINUX) LINUX (2021)

Setup MariaDB on Ubuntu server (remote access, user privileges, upload database)

p>This is most spread operation in Linux and I repeat it again and again in various circumstances.

Now I want to setup MariaDB, configure it to remote access, set up user privileges and upload database.


For check remote connection I will be use MySQL Workbench, unfortunately even installation it to Windows is a problem, because official distribution from Oracle don't working now https://dev.mysql.com/downloads/workbench/.



So, right link in this page other download.



Of course this way is not need if you want to connect to server only from Linux. In this case we need only:

# apt-get install mariadb-client
# mysql -u admin -h xxx.xxx.xxx.xxx -p

And we go ahead to server.




Save dump.


> sudo mysql -u root -p -h localhost
> use cryptochestmax;
> show tables;
> mysqldump -u cryptochest -p ---port=33306 cryptochestmax Coin > cryptochestmax.Coin.$(date +%Y-%m-%d-%H.%M.%S).sql


Comments ( )
<00>  <01>  <02>  <03>  <04>  <05>  <06>  <07>  <08>  <09>  <10>  <11>  <12>  <13>  <14>  <15>  <16>  <17>  <18>  <19>  <20>  <21>  <22>  <23
Link to this page: //www.vb-net.com/MariaDbSetUp/Index.htm
<SITEMAP>  <MVC>  <ASP>  <NET>  <DATA>  <KIOSK>  <FLEX>  <SQL>  <NOTES>  <LINUX>  <MONO>  <FREEWARE>  <DOCS>  <ENG>  <CHAT ME>  <ABOUT ME>  < THANKS ME>