SA-MP Forums

Go Back   SA-MP Forums > SA-MP Server > Server Support

Reply
 
Thread Tools Display Modes
Old 13/03/2015, 02:11 PM   #1
biker122
Gangsta
 
Join Date: Feb 2014
Posts: 766
Reputation: 59
Default Configuring mysql stuffs on VPS

Hi, I'm having a VPS with CentOS 6 x86_64 (Probably 64 bit.)
I'm done uploading stuffs to the VPS server, but I can't find a way to install and use mysql/phpmyadmin..
Things what I've done during installation:
1) Installed the EPEL Repositories.
2) Installed PHP-MYSQL, MYSQL-SERVER packages.
3) Created a user for mysql use.
4) Started the mysql and http services (service mysqld start and service httpd start)
When I access the site, http://vps_ip_address/phpmyadmin I just get "The requested URL /phpmyadmin was not found on this server."

Can someone help me in configuring this?
__________________
k
biker122 is offline   Reply With Quote
Old 13/03/2015, 02:28 PM   #2
Sithis
Gangsta
 
Join Date: Mar 2013
Location: the Netherlands
Posts: 887
Reputation: 79
Default Re: Configuring mysql stuffs on VPS

phpmyadmin isn't a part of mysql server, try:

Quote:
sudo yum install phpmyadmin
__________________
Developer and owner of https://trinityrpg.com
Sithis is offline   Reply With Quote
Old 13/03/2015, 02:31 PM   #3
biker122
Gangsta
 
Join Date: Feb 2014
Posts: 766
Reputation: 59
Default Re: Configuring mysql stuffs on VPS

Looks like I didn't mention that one, I've already installed phpmyadmin..
__________________
k
biker122 is offline   Reply With Quote
Old 13/03/2015, 02:36 PM   #4
Sithis
Gangsta
 
Join Date: Mar 2013
Location: the Netherlands
Posts: 887
Reputation: 79
Default Re: Configuring mysql stuffs on VPS

Did you install via yum?

EDIT: try this:

Create a link in /var/www/phpmyadmin like this:

sudo ln -s /your/phpmyadmin/dir /var/www/phpmyadmin
__________________
Developer and owner of https://trinityrpg.com
Sithis is offline   Reply With Quote
Old 13/03/2015, 02:38 PM   #5
biker122
Gangsta
 
Join Date: Feb 2014
Posts: 766
Reputation: 59
Default Re: Configuring mysql stuffs on VPS

Yes I did. I've done everything as the root user.
__________________
k
biker122 is offline   Reply With Quote
Old 13/03/2015, 03:19 PM   #6
biker122
Gangsta
 
Join Date: Feb 2014
Posts: 766
Reputation: 59
Default Re: Configuring mysql stuffs on VPS

Sorry for the double-post!
A small improvement now. I'm now getting "You don't have permission to access /phpmyadmin/ on this server."
__________________
k
biker122 is offline   Reply With Quote
Old 13/03/2015, 03:44 PM   #7
Sithis
Gangsta
 
Join Date: Mar 2013
Location: the Netherlands
Posts: 887
Reputation: 79
Default Re: Configuring mysql stuffs on VPS

Find phpMyAdmin.conf.

By default, it only allows localhost. Also make sure to either allow from YOURIP/all and remove any deny from all
__________________
Developer and owner of https://trinityrpg.com
Sithis is offline   Reply With Quote
Old 13/03/2015, 08:02 PM   #8
kirostar
Huge Clucker
 
Join Date: Aug 2013
Location: Cairo, Egypt
Posts: 220
Reputation: 9
Default Re: Configuring mysql stuffs on VPS

Installation:
1- Add EPEL Repositories:

cd ~
wget http://download.fedoraproject.org/pu...6-8.noarch.rpm

sudo rpm -ivh epel-release*

rm epel-release*

2- Download And Configure MYSQL

sudo yum install mysql-server

sudo service mysqld start

sudo mysql_install_db

sudo mysql_secure_installation
Code:
You will be asked a number of questions:

Enter current password for root: press Enter

Set root password? Y

New password: Type an administrative password here
Re-enter new password: Confirm the password
Remove anonymous users? Y

Disallow root login remotely? Y

Remove test database and access to it? Y

Reload privilege tables now? Y
Your MySQL installation should be up and running. Test that you can log in with the password you set by typing:

mysql -u root -p

Type exit to return to the shell prompt:

exit


3- Download phpMyAdmin

sudo yum install phpmyadmin

4- Configure PhpMyAdmin

sudo nano /etc/httpd/conf.d/phpMyAdmin.conf

sudo service httpd start


It should work.. Try it.
__________________
kirostar is offline   Reply With Quote
Old 13/03/2015, 08:11 PM   #9
Jake187
Gangsta
 
Jake187's Avatar
 
Join Date: Oct 2011
Location: Ottawa, Canada.
Posts: 614
Reputation: 58
Default Re: Configuring mysql stuffs on VPS

The best way to install mySQL and phpmyadmin is as follows.

Download and use the official mySQL Yum Repo at http://dev.mysql.com/downloads/repo/yum/

This repo is officially from mySQL so you will receive the latest updates right away, a guide to install it and mySQL is available at http://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/ simple way to install it is yum install mysql-community-server and make sure mysql-community-libs are installed if not yum install them as well.

Now you will need to install apache which is required for phpmyadmin so basic step is just yum install httpd

And now you will need to install PHP I don't recommend the default PHP version that is offered by the CentOS repo because it's very outdated you can use webstatic which provides the latest PHP releases via repo at https://webtatic.com/packages/php56/

Now as stated on here you have EPEL install phpmyadmin from that so once EPEL repo is enabled when you do yum install phpmyadmin it should be installing version 4.0.10.8

Once you installed everything make sure you securely setup mySQL and start it up, than start up apache and phpmyadmin will be running.

Just to remind you Apache and PHP is required for phpmyadmin to run.
Jake187 is offline   Reply With Quote
Old 13/03/2015, 09:20 PM   #10
Sithis
Gangsta
 
Join Date: Mar 2013
Location: the Netherlands
Posts: 887
Reputation: 79
Default Re: Configuring mysql stuffs on VPS

Did the last two guys even read? He already did that.
__________________
Developer and owner of https://trinityrpg.com
Sithis is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help with these stuffs. iOxide Scripting Help 7 16/09/2014 04:00 PM
Need some help regarding some register stuffs Flaken Scripting Help 2 26/10/2013 08:49 AM
Configuring SQL through scriptfiles Luke_James Server Support 1 22/08/2012 06:55 PM
/adkill and other stuffs.. James_Bourne Help Archive 0 13/08/2011 04:22 PM


All times are GMT. The time now is 10:26 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.