Entradas

Mostrando entradas de julio, 2020

MySql Ejecutar un archivo SQL desde línea de comandos

https://codigoayuda.wordpress.com/2012/05/23/ejecutar-script-sql-desde-mysql/

Create a MySQL database with charset UTF-8

https://dev.mysql.com/doc/refman/5.7/en/charset-applications.html https://dba.stackexchange.com/questions/76788/create-a-mysql-database-with-charset-utf-8

Sistema sencillo de manejo de inventario y ventas sin cabecera unitarias

Imagen
https://github.com/KryptonB/inventory-management-system https://github.com/zaisahil/inventory

Crear usuario en MySQL y permisos

https://askubuntu.com/questions/947805/how-to-upgrade-phpmyadmin-revisited

Instalar MySQL en Android

Instalar MySQL en Android https://parzibyte.me/blog/2018/11/12/instalar-mysql-mariadb-en-android-con-termux/

Instalar servidor web y procesar archivos de PHP: armar una pila LAMPP en Android

Instalar servidor web y procesar archivos de PHP: armar una pila LAMPP en Android https://parzibyte.me/blog/2018/11/14/configurar-instalar-apache-php-7-android-termux/

PHPMyAdmin instalar y descargar

https://www.phpmyadmin.net/downloads/ https://docs.phpmyadmin.net/en/latest/setup.html#quick-install

MariaDB crear usuario y otorgar permisos totaltes

https://stackoverflow.com/questions/5755819/lost-connection-to-mysql-server-at-reading-initial-communication-packet-syste 1) Allow remote connect to MySQL. Edit file: > sudo nano / etc / mysql / my . cnf Comment line: #bind-address = 127.0.0.1 Restart MySQL: > sudo service mysql restart 2) Create user for remote connection. > mysql - uroot - p CREATE USER 'developer' @ 'localhost' IDENTIFIED BY 'dev_password' ; CREATE USER 'developer' @ '%' IDENTIFIED BY 'dev_password' ; GRANT ALL ON *.* TO 'developer' @ 'localhost' ; GRANT ALL ON *.* TO 'developer' @ '%' ; 3) In my case I need to connect remotely from Windows to VirtualBox machine with Ubuntu. So I need to allow port 3306 in iptables: > iptables - A INPUT - i eth0 - p tcp - m tcp -- dport 3306 - j ACCEPT share     improve this answer     follow