Ubuntu Servers :: Can't Access MySQL Remotely Via PhpMyAdmin?
Jan 3, 2011
One server is a dedicated MySQL server. After upgrading that one to Ubuntu 10.04 (from an ancient Suse 9.2), both servers are running Ubuntu 10.04 LTS.I have another server that I use to administer the database server via phpMyAdmin. However since the upgrade it is not able to connect. I get an error #1130 Cannot log in to the MySQL server. The same happens if I try to connect remotely from the command line with: mysql -u root -h 129.79.137.121 -pI'm not sure if this is an iptables/ports problem or a configuration problem on the MySQL end or something else entirely.I've searched and tried the suggestions I've found in various places but none seems to have fixed it.
View 2 Replies
ADVERTISEMENT
Dec 25, 2010
What commands can be used to install software such as "phpMyAdmin" to Fedora? As I am setting up Apache in Fedora. How to install "phpMyAdmin" and setup phpMyAdmin, so that I can use internet explorer to manage the phpMyAdmin to configure the MySQL database remotely.
View 2 Replies
View Related
Jul 29, 2011
The original issue started when i couldnt login to phpmyadmin. I noticed an error when installing it and when trying to login, my credentials that I supplied upon install failed. After ages of messing around trying to reset I decided to try and uninstall phpmyadmin and MySQL and start again. This has produced more issues as I uninstalled MySQL first and phpmyadmin asks for credentials that are in a database, which I have already deleted. This causes major issues trying to uninstall it. Anyway, I have used all these commands:
sudo apt-get remove phpmyadmin
sudo apt-get remove mysql-server
sudo apt-get remove mysql-common
Now I am trying to install everything again but having erros. This is what I have so far:
Code:
root@ks358041:/var/lib/php5# sudo apt-get install mysql-server-5.1
Reading package lists... Done
Building dependency tree
Reading state information... Done
[code]....
View 8 Replies
View Related
Apr 13, 2011
How do I connect to the MySQL server using phpmyadmin?It's asking me for a username and password and I was not asked for a root password when I installed MySQL (unlike in Windows).I tried no password, I tried root as a password, I tried$ mysqladmin -u root -p blahEnter password: mysqladmin: connect to server at 'localhost' failederror: 'Access denied for user 'root'@'localhost' (using password: YES)'Nothing I've tried is working obviously.Why does this have to be so stupid? Why couldn't MySQL ask me what password I want to use?
View 2 Replies
View Related
Apr 27, 2010
I am running Ubuntu 9.10 with Apache, phpMyAdmin and MySQL. Normally phpMyAdmin loads properly, but the other day I created a large database of 6,000+ tables and 1.3 GB of data in the entire database. Now phpMyAdmin loads and shows my different databases, but if I try to open the new large database, it just loads a white page with no content. Does anyone know if I can reconfigure my server so it will be able to show parts of the database?
View 2 Replies
View Related
Feb 13, 2011
I am able to access phpmyadmin via my web browser using either my local ip followed by /phpmyadmin and by using the same layout with localhost. If i use my DNS name provided by no-ip which i bound to in apache2 i am able to get to the "It works!" page with the domain name but if i use /phpmyadmin after it, it will tell me that there is no such directory.
View 1 Replies
View Related
Jul 6, 2011
I'm setting up a home web server using LAMP that I want to use to access files and practice coding, but I am very new to Linux and web servers. I currently have it so I can access phpMyAdmin and the test pages locally through my internal IP, but whenever I try to access it through the external IP I get this router management console that I don't know the password or username to. I know my router login and password and it's not the same as that. I've forwarded port 80 and when that didn't work I tried changing /etc/apache2/ports.conf to 8080 and I forwarded that port on my router with no luck too.
It doesn't seem to matter if I have any ports forwarded, though, it still brings me to the same screen regardless. Also, I have set up a static IP on the server by modifying the /etc/network/interfaces file. I've attached a screenshot with the actual router management console screen. I won't have access to the server until later, but, if you require any output from the server I will be sure to post it as soon as I get home. I'm not using ubuntu for my webserver, but debian instead because ubuntu server had a whole bunch of problems with my PCMCIA network card. Ubuntu suggestions should work just fine, but I just thought I should clarify.
View 9 Replies
View Related
Oct 15, 2010
I installed ubuntuserver edition 10.10 on my old p3.Installation went fine and i installed LAMP and SSH along with it.*everyhting i do past this point is via LAN on my laptop using root account on putty or winSCP.*I installed phpmyadmin, loged in with root, duplicated the root acount and gave the duplicate any host (%) access. Next i created an account with access only to the users database (for use in my php to check username and password).Next thing i did was change the apache2 config 000-default to disable indexing.After that i changed the php.ini file to allow 6GB uploads (for movies).Rebooted... and thats where the problems start.I CANT:Acces phpmyadmin with any acount.Login on my website.I CAN:login to mysql using root.I HAVE:Checked if the mysql database and table for websitelogin still existed, they do.Checked mysql useracounts and they are still there.So something changed after the reboot, because it was working fine before i did.
View 9 Replies
View Related
Oct 27, 2010
I am trying to set up a server for a client and they want remote access to the phpmyadmin program on the server with a dyndns
I've spent the past 2 hours on google with sadly no luck
So how can i go about setting this up?
View 1 Replies
View Related
Jun 12, 2010
I have been trying to set up phpmyadmin for a while now, but I just cant seem to access it with the browser.
I yum installed phpmyadmin. In my /etc/httpd/conf.d/phpMyAdmin.conf I have:
When I visit [ip]/phpmyadmin I just get a 404
I've reloaded apache, checked the phpmyadmin config file, and everything seems fine, I just get constant 404.
View 2 Replies
View Related
Jan 14, 2011
i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[code]....
View 4 Replies
View Related
Jul 3, 2011
i setup a localhost in my system. but am not getting access to the phpmyadmin by entering the user name and password i entered at the time of set up. the /etc/phpmyadmin/config-db.php file is shown below.
<?php
##
## database access settings in php format
## automatically generated from /etc/dbconfig-common/phpmyadmin.conf
## by /usr/sbin/dbconfig-generate-include
[code]....
when i access http://localhost/phpmyadmin/ , the login screen appears but entering the username and password as in the file gives the error #1405 cannot log into mysql server.
View 3 Replies
View Related
Jan 30, 2010
i have fedora 11 installed in my laptop and apache server by default. after starting httpd and mysqld services i was able to access localhost through browser.(e.g. [URL]). before installing phpMyAdmin everything goes right. after installing phpMyAdmin it created problem in localhost. now typing [URL] it opens joomla site but without images and without intending of content. when i type [URL] in browser it ask for user name and password. i already provide user name(root) and password(my_root_password) in /etc/phpMyAdmin/config.inc.php. but it doesnt open.
View 1 Replies
View Related
Mar 16, 2010
I encountered a problem when I am trying to access my phpmyadmin the error came up: Wrong permissions on configuration file, should not be world writable!
View 6 Replies
View Related
Mar 9, 2011
I came back to see on the screen a message requesting remote desktop control. So I said no and went into remote desktop and said never allow connection. I had recently hosted a PHP app on the home pc for testing purposes using apache. Here are some of the last logs entries:
Code:
127.0.0.1 - - [08/Mar/2011:18:26:34 -0500] "POST /z3950search.php HTTP/1.1" 200 1731 "http://localhost/z3950search.php" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.15) Gecko/20110303 Ubuntu/10.10 (maverick) Firefox/3.6.15"
127.0.0.1 - - [08/Mar/2011:18:26:37 -0500] "GET /favicon.ico HTTP/1.1" 404 500 "-" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.15) Gecko/20110303 Ubuntu/10.10 (maverick) Firefox/3.6.15"
127.0.0.1 - - [08/Mar/2011:18:26:38 -0500] "GET /favicon.ico HTTP/1.1" 404 500 "-" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.15) Gecko/20110303 Ubuntu/10.10 (maverick) Firefox/3.6.15" .....
View 2 Replies
View Related
Aug 5, 2011
Is there any way to install a Ubuntu server and access the server remotely via a Ubuntu desktop environment instead of a SSH command line?
I will be installing a Ubuntu server in an office where the office manager will need to be able to do simple things like add/remove users, access filesystems, etc. She can handle these tasks in Ubuntu desktop/GUI, but it is impractical for her to have to learn how to use the CLI terminal to do this stuff.
Will I have to install desktop Ubuntu on the server to do this, or can I install Ubuntu server version and setup another computer Ubuntu desktop to remotely login graphically?
View 1 Replies
View Related
Feb 5, 2010
I set up mod_proxy in order to get rid of :8080 now I cant access phpmyadmin through the browser. what is the quickest way to turn off mod_proxy and access phpmyadmin? I would like to optimize the tables and back up the sql file. I just need to turn it on for a bit, and then enable mod_proxy again.Right now, if I got to localhost/phpmyadmin, it redirects to the main application.
I have used a2enmod, and added
sudo a2enmod proxy
sudo a2enmod proxy_http
sudo a2enmod proxy_ajp
[Code]...
View 2 Replies
View Related
Jul 15, 2010
When you access mysql within the same Apache server (same ip address) via php, do you need to GRANT user ip in order to login to mysql?
Where are the log files for php, mysql etc?
View 4 Replies
View Related
Dec 11, 2010
I'm running an Ubuntu 9.04 Minimal server and trying to get MySQL to work correctly. But when I try to access MySQL with the root user it doesn't want to.
Code:
mysql -u root -p
Enter password:
[code]....
View 4 Replies
View Related
Jul 22, 2011
I erased Windows a week ago and is loving Ubuntu 10.04 (which changed to xubuntu after installing Qimo for Kids??) ever since. Now I want to get coding again and PHP is working fine, but I can't access mysql!?I followed a ton of guides, completely removed, reinstalled etc. Nothing works.Here some stuff that might be interresting. I can't remember the "ls" and "awk" and "grep" commands to use, so please guide me if you need more info.
sudo mysql status
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
sudo update-rc.d mysql defaults
update-rc.d: warning: /etc/init.d/mysql missing LSB information
[code]...
View 4 Replies
View Related
Aug 15, 2010
We started our project (it's a website "employee performance appraisal system") in windows by starting with some html forms and then slowlyadded php ,javascript and other stuff in windows we had no issues of insertion and retrieval of data from thedatabase.Now,we decided to shift the entire stuff to drupal the html forms along with those php files but we had 2 issues with this1. the first one was ..we created "page" for each html form and copied the html code into "page" but we didn't find where our pages are getting stored (do they get stored in mysql database that we create for drupal siter do they remain as html pages somwhere?)2.second problem was ...for admin in drupal I gave the username "root" and a password ..similarly for mysql also I gave a password.
now I used phpmyadmin and created another database called "appraisal" which is supposed to hold the data of our website.when I try to insert data into one of the tables of this database (attendance table) ,the following error occured "Attempt to connect failed access denied for user 'root'@'localhost'(using password:NO) cannot run querry insert intoattendance values('x','y')" Access denied for user 'root'@'localhost' (usingpassword:NO)Also I'm unable to access mysql as a normal user only super user can access and can we unset the password that's required to reach mysqlprompt?
View 2 Replies
View Related
Jun 11, 2011
I configured the server freeradius with mysql and I think I configured well freeradius and mysql but when I m testing my configuration with:
radtest nezar azerty 127.0.0.1 0 azerty1234
I have always:
rad_recv: Access-Reject packet from host 127.0.0.1 port 1812, id=108, length=20
View 1 Replies
View Related
Aug 22, 2010
I have 2 Servers
Server A running apache, php, phpmyadmin
Sever B running MySQL
Server A has IP of 192.168.1.110
Server B has IP of 192.168.1.120
I edited /etc/phpmyadmin/config.inc.php
To have these:
(This par was confusing to I just re-added the line above instead of searching for it all).
Then I set the MySQL vi /etc/mysql/my.cnf to comment out #bind-address = 127.0.0.1
There is another line that most of the guides asked me to comment out but I cannot find that like: # skip-networking
The Next closest match to that is: skip-external-locking
I will assume that is not it and leave it alone....
I keep getting errors for example: "Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly"
Another error was it canno connect because it is not accepting connections from the IP Address of my webserver...
View 2 Replies
View Related
Jan 13, 2010
I am up and running. Symptom: webapp/servlet deployed to Tomcat, utilizes JDBC driver for MySQL connectivity. Upon launching application in browser and performing action requiring database interaction, exception thrown, server log:
[Code]...
View 1 Replies
View Related
Jul 3, 2010
I have Virtualbox setup
WinXP Host
Ubuntu 10.04 is the guest
Mysql is installed in ubuntu and it works fine in the guest (ubuntu)
Internet works fine in the host and the guest. Bridged Network.
Now, here is the thing... i want to access mysql from my host to load some data into it.
how do i access mysql from my host Win XP?
View 3 Replies
View Related
Apr 15, 2011
I can not access my MySQL database from any remote host on my home network, I keep getting "Access denied for user 'dbuser'@'192.168.1.10' (using password: YES)"
From what I've read this seems to be a permission problem, I tried
'dbuser'@localhost';
'dbuser'@'%';
'dbuser'@'192.168.1.10';
and between each change of permission, I've flushed privileges.
View 1 Replies
View Related
Aug 22, 2010
I been going off old outdate guides and informaion around the internet and nothing is working
I have 2 Servers
Server A running apache, php, phpmyadmin
Sever B running MySQL
Server A has IP of 192.168.1.110
Server B has IP of 192.168.1.120
[Code]...
(This par was confusing to I just re-added the line above instead of searching for it all).
Then I set the MySQL vi /etc/mysql/my.cnf to comment out #bind-address = 127.0.0.1 There is another line that most of the guides asked me to comment out but I cannot find that like: # skip-networking
The Next closest match to that is: skip-external-locking
I will assume that is not it and leave it alone....
I keep getting errors for example: "Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly"
Another error was it canno connect because it is not accepting connections from the IP Address of my webserver..
View 2 Replies
View Related
Feb 1, 2010
I'm totally new to MySQL / PHPAdmin and have been dropped in at the deep end regarding getting MySQL and phpMyAdmin upgraded... When I look at the RPM's I see:
php-mysql-4.2.2-17.2
php-4.2.2-17.2
php-imap-4.2.2-17.2
php-ldap-4.2.2-17.2
But when I go to the GUI I see: Welcome to phpMyAdmin 2.5.7-pl1 MySQL 4.0.16-standard-log running on localhost as root@localhost So to start with I'm not totally sure what version I'm running! I need to get these upgrades done due to PCI requirements so they are saying to upgrade to at least 4.0.25 I'm currently running RedHat9 so ideally need to know the easiest way to upgrade to a later 4.0 or 4.1 version.
View 6 Replies
View Related
Aug 30, 2010
I have a centos 5.5 machine. First I upgraded my php to php 5.3. So I was then installing phpMyAdmin so I just put the whole folder into my /var/www/html/phpMyAdmin.The I tried to run my phpMyAdmin and I got this error Cannot load mysql extension. Then I uinstall my mysql db and reinstall it. Again it show me the same error.For addition info via the php info page for the Configure Command I saw this option -without-mysql' .
View 5 Replies
View Related
May 4, 2010
I am at work right now and noticed my blog is down because of a database connection error. phpmyadmin wont load either it says theres an error, and webmin wont load either. So what would cause a mysql to go down? a hack or update? i am running ten.o four ubuntu server.
View 3 Replies
View Related
