[RESOLVED] running a database how?

[Raymondday]

I did this:

$this->bbcode_second_pass_code('', 'pacman -S phpmyadmin') it worked good. But it can't be display when I go to "http:/ip/phpmyadmin" I want to set up a database and I all ready did. I found were pacman put phpmyadmin here "/usr/share/webapps/phpMyAdmin/" but how do I get it to run in Apache? I got phpadmin working by going here.

$this->bbcode_second_pass_code('', 'pacman -S apache php php-apache mysql') That worked good too. But when I go to start mysqld like this:

$this->bbcode_second_pass_code('', '[root@alarm http]# /etc/rc.d/mysqld start
:: Starting MySQL Server [FAIL]
[root@alarm http]#')

It FAIL's. I guess I need to set up some setting but I wanted to set it up in phpmyadmin but can't get that to run.

I search for "phpmyadmin" on here and did not find it any place.

-Raymond Day

[WarheadsSE]

https://wiki.archlinux.org/index.php/MySQL

And for giggles: http://ubuntuforums.org/showthread.php?t=801607

[pepedog]

You are a card. Is that just a British phrase?

[Raymondday]

I went to both links you gave WarheadsSE the wiki one looked good. At lest the things were in the right folders. But it still did not work for me. Here is my typing to get it working. I used WinSCP to make files were the fist link said. But I guess that part is not for me.


$this->bbcode_second_pass_code('', 'login as: root
root@192.168.2.114's password:
Last login: Mon Nov 21 01:46:32 2011 from 192.168.2.101
[root@alarm ~]# /etc/rc.d/mysqld start && mysql_secure_installation
:: Starting MySQL Server [FAIL]
[root@alarm ~]# /etc/rc.d/mysqld restart
:: Stopping MySQL Server [FAIL]
:: Starting MySQL Server [FAIL]
[root@alarm ~]# DAEMONS=(... mysqld ...)
[root@alarm ~]# systemctl start mysqld.service
-bash: systemctl: command not found
[root@alarm ~]# mysql -p -u root
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
[root@alarm ~]#')

-Raymond Day

[WarheadsSE]

...

systemctl is UBUNTU command...

Pay attention.$this->bbcode_second_pass_code('', 'rc.d restart mysqld')

Also, if the server isn't running, how is the client going to connect to it?

Perhaps you should read the logs?

[Raymondday]

I thought this my work but still did not.

$this->bbcode_second_pass_code('', '[root@alarm ~]# pacman -S mysql
warning: mysql-5.5.17-1 is up to date -- reinstalling
resolving dependencies...
looking for inter-conflicts...

Targets (1): mysql-5.5.17-1

Total Download Size: 0.00 MB
Total Installed Size: 74.11 MB

Proceed with installation? [Y/n]
(1/1) checking package integrity [######################] 100%
(1/1) checking for file conflicts [######################] 100%
(1/1) upgrading mysql [######################] 100%
warning: directory permissions differ on var/lib/mysql/
filesystem: 775 package: 700
[root@alarm ~]# /etc/rc.d/mysqld start && mysql_secure_installation
:: Starting MySQL Server [FAIL]
[root@alarm ~]#')

-Raymond Day

[WarheadsSE]

$this->bbcode_second_pass_code('', 'warning: directory permissions differ on var/lib/mysql/
filesystem: 775 package: 700')

Ok, maybe it's time to check the directory, as well as check the CONFIGURATION FILE for mysql.

I linked specifically to a permissions issue example.

[Raymondday]

I changed the DIR to 700 and started it again it did not say the same that time but it still don't start.

[WarheadsSE]

Have you read the logs yet? They're probably chock-full of useful error messages.

[xenoxaos]

+1