[SOLVED] Installed mySQL and no longer able to access

[jettdigitals]

Greetings to the Community!

I have the Pogo V4 (pogo-v4-a1-01)and have installed archlinux on attached USB drive (not thumb drive) to run a local server. Basically to develop and test in PHP environment.

Using the thread at viewtopic.php?f=53&t=5024 as guideline, installed mySQL (or should say "attempted").

Now my USB drive is flashing red and cannot login via putty telnet.

Was able to login before. Using putty I am asked to login and asked for password BUT after minute or two get a popup saying "Network error: Software caused connection abort".

Below is the method used to try and install mySQL:
$this->bbcode_second_pass_code('', '[root@alarm ~]# pacman -S mysql
:: There are 2 providers available for mysql:
:: Repository extra
1) mariadb
:: Repository community
2) percona-server

Enter a number (default=1): 1
resolving dependencies...
looking for inter-conflicts...

Packages (4): libaio-0.3.109-7 libmariadbclient-10.0.12-1 mariadb-clients-10.0.12-1 mariadb-10.0.12-1

Total Download Size: 15.33 MiB
Total Installed Size: 135.72 MiB

:: Proceed with installation? [Y/n] Y
:: Retrieving packages ...
libaio-0.3.109-7-arm 4.1 KiB 1368K/s 00:00 [################################################] 100%
libmariadbclient-10.0.12-1-arm 3.7 MiB 785K/s 00:05 [################################################] 100%
mariadb-clients-10.0.12-1-arm 839.7 KiB 818K/s 00:01 [################################################] 100%
mariadb-10.0.12-1-arm 10.8 MiB 807K/s 00:14 [################################################] 100%
(4/4) checking keys in keyring [################################################] 100%
(4/4) checking package integrity [################################################] 100%
(4/4) loading package files [################################################] 100%
(4/4) checking for file conflicts [################################################] 100%
(4/4) checking available disk space [################################################] 100%
(1/4) installing libaio [################################################] 100%
(2/4) installing libmariadbclient [################################################] 100%
(3/4) installing mariadb-clients [################################################] 100%
(4/4) installing mariadb [################################################] 100%
Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
140720 9:34:06 [Note] InnoDB: Using mutexes to ref count buffer pool pages
140720 9:34:06 [Note] InnoDB: The InnoDB memory heap is disabled
140720 9:34:06 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
140720 9:34:06 [Note] InnoDB: Compressed tables use zlib 1.2.8
140720 9:34:06 [Note] InnoDB: Using Linux native AIO
140720 9:34:06 [Note] InnoDB: Not using CPU crc32 instructions
140720 9:34:06 [Note] InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(135987200 bytes) failed; errno 12
140720 9:34:06 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
140720 9:34:06 [ERROR] Plugin 'InnoDB' init function returned error.
140720 9:34:06 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140720 9:34:06 [ERROR] mysqld: Out of memory (Needed 130760704 bytes)
140720 9:34:06 [ERROR] mysqld: Out of memory (Needed 98058240 bytes)
140720 9:34:06 [ERROR] mysqld: Out of memory (Needed 73531392 bytes)
140720 9:34:06 [ERROR] Unknown/unsupported storage engine: InnoDB
140720 9:34:06 [ERROR] Aborting

140720 9:34:07 [Note] /usr/sbin/mysqld: Shutdown complete


Installation of system tables failed! Examine the logs in
/var/lib/mysql for more information.

The problem could be conflicting information in an external
my.cnf files. You can ignore these by doing:

shell> /usr/scripts/scripts/mysql_install_db --defaults-file=~/.my.cnf

You can also try to start the mysqld daemon with:

shell> /usr/sbin/mysqld --skip-grant --general-log &

and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:

shell> /usr/bin/mysql -u root mysql
mysql> show tables;

Try 'mysqld --help' if you have problems with paths. Using
--general-log gives you a log in /var/lib/mysql that may be helpful.

The latest information about mysql_install_db is available at
https://mariadb.com/kb/en/installing-system-tables-mysql_install_db
MariaDB is hosted on launchpad; You can find the latest source and
email lists at http://launchpad.net/maria

Please check all of the above before submitting a bug report
at http://mariadb.org/jira

synchronizing filesystem...
[root@alarm ~]#')

How the heck can I reset so able to login as root? Have spents hours setting up and please do not tell me to start over, lol.

Any input will be greatly appreciated.

EDIT: Forgot to add that server is working fine and can access via port 80. All test pages are working fine.

[jettdigitals]

Okie dokie.

Solved my issue. Forgot I had Webmin installed and used it to disable mySQL at startup. Can now login with putty.