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.
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.
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:
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?
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?
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.
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.
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.
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.
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.
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!
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:
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?
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
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.
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
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?
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
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...
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:
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.
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
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..
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:
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.
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' .
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.