02-25-2017, 01:42 PM
im not at all familiar with xampp. But it may have bound to the computers actual local ip address it should how ever still respond to localhost or 127.0.0.1. But we all know how computers are sometimes. Chances are its just a database error not being set up at all, or configured wrong.
mudmin way should work but we each have our own way
so ill make you a small walk through on how i do it
with phpmyadmin
now i run apache2 with mysql on ubuntu 14.04 i have multiple instances of Ubuntu and Debian 8 using this single mysql server. the mysql is installed on the web server i run the same program Multicraft (its for minecraft) on mutiple physical servers but the banning suite and mutlicraft databases are located on the main web server that that runs the main proxy for the minecraft called bungeecord. i have combined power usage of my system is approx 1500 watts at full load it idles down in the high 500's so it does cost me quite a lot to run them approx 140 dollars a month.
i esplained that simply so this next part made sense when i make my database using anyhost {3bc1fe685386cc4c3ab89a3f76566d8931e181ad17f08aed9ad73b30bf28114d} vs localhost its becase its the only mysql server i use.
step 1
login to phpmyadmin using localhost/phpmyadmin
now locate the users tab on the top upper left third of the screen
http://prntscr.com/ed7gkz
step 2
click on add user bottom left third of the screen
http://prntscr.com/ed7gr8
step 3
fill in the username i used test use what ever you want
make sure the host line says anyhost on the drop down to the left of the editable field
i allow phpmyadmin to generate a password for me
check the box thats half way down on the left thrid that says create database with the same name and grant all privileges
ignore everything else on the page scroll to the bottom after you have copyied your password (or made your own) click on go bottom right side of the screen.
http://prntscr.com/ed7hnb
step 4
fill in the info on the install step i am showing you a copy of my init.php because i no longer have the install files
fill in the host info mine shows the local ipaddress of the server
user name
password
and database name this will be the same as the user name because we checked the box that said create database with the same name and grant all privileges
http://prntscr.com/ed7ln9
this method will ONLY work if your machine has a static ipaddress i cannot stress that enough if it doesn't have a static ip it will work for a while then it will break in a few days typically.
to find your local ip address open up a terminal (cmd prompt in windows)
on windowes open command prompt and type in ipconfig
http://prntscr.com/ed7msq
on mac/linux use ifconig -a
http://prntscr.com/ed7nn5
to assign a static ip address on windows follow this guide
https://www.howtogeek.com/howto/19249/ho...windows-7/
for mac use this guide
http://www.macinstruct.com/node/550
on linux its actually simpler imo
step 1 ifconfig -a make note of your settings mostly just the ipaddress and the interfaces name eg mines em3 it could be eth0 or a number of things
http://prntscr.com/ed7nn5
step 2
for the sake of this im going to use the nano editor but use the one you want there is a few of them
type this command in sudo nano /etc/network/interfaces
if your logged in linux as root you don't need sudo
it will open this screen
http://prntscr.com/ed7r1r
if it already is static it will look like mine others wise the line on mine that says iface em3 inet static will say iface em3 inet dhcp
change that line to
iface em3 intet static
address (your local ip address) xxx.xxx.xxx.xxx
netmask 255.255.255.0 (or what ever your netmask it probally 255.255.255.0 its the most common
gateway (what ever your routers local ip address is. or your dhcp servers ipaddress)
dns-nameservers 8.8.8.8 (this is googles free dns server)
then hit ctrl x then hit y then hit enter
mow restart the networking service or just restart the computer what ever is easier for you
i did this as a wide help simply because for some reason i can see this happening often enough
R
mudmin way should work but we each have our own way
so ill make you a small walk through on how i do it
with phpmyadminnow i run apache2 with mysql on ubuntu 14.04 i have multiple instances of Ubuntu and Debian 8 using this single mysql server. the mysql is installed on the web server i run the same program Multicraft (its for minecraft) on mutiple physical servers but the banning suite and mutlicraft databases are located on the main web server that that runs the main proxy for the minecraft called bungeecord. i have combined power usage of my system is approx 1500 watts at full load it idles down in the high 500's so it does cost me quite a lot to run them approx 140 dollars a month.
i esplained that simply so this next part made sense when i make my database using anyhost {3bc1fe685386cc4c3ab89a3f76566d8931e181ad17f08aed9ad73b30bf28114d} vs localhost its becase its the only mysql server i use.
step 1
login to phpmyadmin using localhost/phpmyadmin
now locate the users tab on the top upper left third of the screen
http://prntscr.com/ed7gkz
step 2
click on add user bottom left third of the screen
http://prntscr.com/ed7gr8
step 3
fill in the username i used test use what ever you want
make sure the host line says anyhost on the drop down to the left of the editable field
i allow phpmyadmin to generate a password for me
check the box thats half way down on the left thrid that says create database with the same name and grant all privileges
ignore everything else on the page scroll to the bottom after you have copyied your password (or made your own) click on go bottom right side of the screen.
http://prntscr.com/ed7hnb
step 4
fill in the info on the install step i am showing you a copy of my init.php because i no longer have the install files
fill in the host info mine shows the local ipaddress of the server
user name
password
and database name this will be the same as the user name because we checked the box that said create database with the same name and grant all privileges
http://prntscr.com/ed7ln9
this method will ONLY work if your machine has a static ipaddress i cannot stress that enough if it doesn't have a static ip it will work for a while then it will break in a few days typically.
to find your local ip address open up a terminal (cmd prompt in windows)
on windowes open command prompt and type in ipconfig
http://prntscr.com/ed7msq
on mac/linux use ifconig -a
http://prntscr.com/ed7nn5
to assign a static ip address on windows follow this guide
https://www.howtogeek.com/howto/19249/ho...windows-7/
for mac use this guide
http://www.macinstruct.com/node/550
on linux its actually simpler imo
step 1 ifconfig -a make note of your settings mostly just the ipaddress and the interfaces name eg mines em3 it could be eth0 or a number of things
http://prntscr.com/ed7nn5
step 2
for the sake of this im going to use the nano editor but use the one you want there is a few of them
type this command in sudo nano /etc/network/interfaces
if your logged in linux as root you don't need sudo
it will open this screen
http://prntscr.com/ed7r1r
if it already is static it will look like mine others wise the line on mine that says iface em3 inet static will say iface em3 inet dhcp
change that line to
iface em3 intet static
address (your local ip address) xxx.xxx.xxx.xxx
netmask 255.255.255.0 (or what ever your netmask it probally 255.255.255.0 its the most common
gateway (what ever your routers local ip address is. or your dhcp servers ipaddress)
dns-nameservers 8.8.8.8 (this is googles free dns server)
then hit ctrl x then hit y then hit enter
mow restart the networking service or just restart the computer what ever is easier for you
i did this as a wide help simply because for some reason i can see this happening often enough
R