Software :: Phpmyadmin Stopped Working - Installing Mysql-server
Jul 23, 2010
My phpmyadmin stopped working. I reinstalled it and it gives error #2002. I found that this error is from mysql, which i couldn't repair and i begin to reinstall it. First I was with Debian 5.03, but i played with /etc/apt/sources.list and after upgrading
I have now 5.05
The problem is that when i install mysql-server a dependency appear in mysql-server-5.0. I follow this instructions[url] and after sudo apt-get install mysql-server mysql-client
I get this error:
Code:
How can i fix this dependency? I didn't find anything relative in google.
mysql-server-5.0 --configure gives error: command not found
I uninstalled all related with mysql and execute dpkg --purge mysql-server then reboot and run first apt-get install mysql-server-5.0 mysql-client-5.0 and then apt-get install mysql-server mysql-client There was no error
Code:
But there was another error when run mysql -u root -p
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 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 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..
Windows XP Pro, VMware and Kubuntu as the guest. Tried several different ways of adding LAMP server, via the Konsole and also via Synatpic and although I can get into localhost and it says "it works" doesn't actually take me to a list which includes the links to Apache and phpmyadmin like some tuts show. Also if I make the php test page that also works, but I cannot get phpmyadmin to work. When I look in the var/www folder there are only 3 files there and not the apache2 and phpmyadmin folders as shown on a lullabot tutorial.
Summary: Does a discrepancy between MySQL client library 5.0.x and MySQL server of 5.1.50 cause "inconsistent behavior", as reported by phpMyAdmin? The longer version: Windows Sysadmin taking the plunge into Linux. I tried to spare you all the rookie questions and did a fair bit of reading. I'm rather happy I was able to get CentOS 5.5 installed and running, configured iptables, got the kernel updated, Apache, MySQL and PHP installed. Then upgraded PHP to 5.2 after I figured out how repos and priorities work.
I got phpMyAdmin installed and running, then decided to upgrade from 2.11 to 3.3.7 but it keeps complaining that my MySQL client libraries are something like 5.0.63, while my server is 5.1.50, and this may cause "inconsistent behavior" or something of the like. So, feeling industrious, I decided to find an updated client.
MySQL-client-community-5.1.50-1.rhel5.i386.rpm
But it wouldn't let me install it as it conflicted with the default mysql-server installation. I also couldn't remove just the old client, to update to a newer one. So I blew away everything mysql on my server and installed the above client
MySQL-server-community-5.1.50-1.rhel5.i386.rpm
and that server file. I'm assuming I'm missing dependencies now as phpMyAdmin claims it can't load the mysql extension. Attempting to 'yum' php-mysql tried to install 'mysql' as a dependency, which immediately conflicted with the files I'd installed. At this point I'm wondering if I'm closing in on successfully installing a version that phpMyAdmin doesn't complain about, or if I should even care that it is complaining and just go back to all the repo versions of everything.
# rpm -e MySQL-shared-community-5.1.50-1.rhel5.i386.rpm error: package MySQL-shared-community-5.1.50-1.rhel5.i386.rpm is not installed
I use Debian 6 as my main distro, installed on partition 1 (sda1) on my laptop. After installing a second distro on sda2 everything still worked fine and both distros show up on the boot up screen. After installing a 3rd distro on sda3; suddenly my cursor (in Debian) is frozen and I can't use either the touch-pad or the 'left and right clickers'. It seems unlikely that this would have anything to do with installing another distro but on the other hand it is a bit of a coincidence...or? The cursor works on the 2nd OS. The 3rd has not yet showed up on the boot screen (I want to do a 'update-grub from within Debian)
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:
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' .
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.
So the problem is that phpMyAdmin does not want to connect to host name (at remote server) but connects to that same server fine if it's ip address is used. Command line "mysql -h hostname ..." works fine and connects to host name. Mysqladmin also works.
it's giving error:
***** Error
MySQL said: #2005 - Unknown MySQL server host 'host.name' (2) ******
I've disabled SElinux and temporarily disabled Iptables but no luck.
Somehow I feel MySQL is not doing DNS lookup when used by Apache/PHP. So it just understands ip addresses.
I found that on MySQL startup you can disable DNS lookup. [URL] Not sure if it's disabled and how to enable it at startup. Could not find anything at "System" -> "Administration" -> "Services".
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 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.
I just install Ubuntu on a new computer I got, and set up LAMP. I started poking around in MySQL (more than I should have) and managed to break it. I've been trying to fix it, but I can't. I've done apt-get --purge mysql-client, but when I reinstall it it's the same thing. How can I reinstall MySQL (and PHPmyadmin) from a completely clean slate? (There's no important data on there)
After a new install of Slackware 12.2, I carried out the following procedures to get everything working successfully right out of the box. The server is a standalone system, used for testing and educational purposes, so please bear that in mind. NB: Throughout this post when you see a single # at the start of a line it means you are typing the commands as root user. You should not include the #, only the text after it.
### setup Apache with php enabled Login as root user on your Slackware box and type: # pico -w /etc/httpd/httpd.conf
I have installed on a remote server phpmyadmin 3.3.1 and mysql 5.1.46 on a centos 5.4 OS.
Any newly created user with phamyadmin is unable to login both from mysql command line (from localhost) and phpmyadmin (localhost and remotely).
No prob when the user is created with mysql command line (from localhost). All of the users created with phpmyadmin, are not "visible" recognized from the show user command via the mysql command line. The setting I used when I create any user was the same as the ones with the mysql command line creation.
The error message I get when accessing from mysql command line (from localhost) is the following: "Access denied for user ... @localhost (using password: yes)"
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.
I tried to install the package from centosplus repo but got the error cannot find libmysqlclient.so.15.Not surprising as I have libmysqlclient.so.18. If not does anyone know how I can build postfix with support for MySQL 5.5. It doesn't help that I have never built a binary before - I found a couple of good tutorials on how to build from source that seem straight forward enough but I have no idea what needs to be specified for the postfix build.
I installed:MySQL-server-5.1.48-1.glibc23.i386.rpm MySQL-client- .1.48-1.glibc23.i386.rpmand can now type "MySQL" at the command prompt to play around with MySQL! W00t!
However, when trying to import MySQLdb into python, I get this error: >>> import MySQLdb ImportError: libmysqlclient_r.so.15: cannot open shared object file: No such file or directory ... and now I'm clueless. I tried looking for libmysqlclient_r.so.15 by typing "sudo find / -name 'libmysqlclient_r.so.15'" and didn't get anything
There are a few threads about this but none seem to me.I have 3 machines setup with a nfs home directory on machine 1.I have created keys using ssh-keygen -t rsa (and left everything blank), then as user on machine 1 run
this used to work until I upgraded to ubuntu 11.04 (from 9.04), and now it requires a password to ssh. I have tried several times deleting ~/.ssh/* and recreating, to no luck Below is the results when I try to ssh into -2 from -1:
[Code]...
(dumb question, but shouldn't the offered RSA public key be id_rsa.pub rather than id_rsa?)
I'm trying to install DekiWiki, which has as a dependency mysql-server. This is what's going on:
Code: root@servername:~# apt-get install mysql-server Reading package lists... Done Building dependency tree Reading state information... Done The following extra packages will be installed:
[Code]...
Do you think this package might be corrupted, and if so can I manually specify a different version or a different package? I don't know what else to do; ctrl+c to kill it results in dpkg hangups that yeah, I can purge, but I'd rather not be doing that more than is really necessary.
I have been fighting with this for days. I upgraded from etch to lenny. I tried installing mysql-5.1. I have uninstalled, reinstalled, updated, upgraded, many, *many*, times. It just stubbornly refuses to work.
I successfully set-up an FTP server, that worked great and perfectly, but after restarting the computer, it has stopped working.None of my router's settings have changed. I restarted the vsftpd process.
I'm in somewhat of a sticky situation. ssh has just randomly stopped working on my server after a power failure. Everything else that doesn't rely on ssh is still working fine though. It can still receive mail and everything, just no ssh.Background on the server, running debian etch on a PPC machine.ssh is (supposed to be) running on port 2000. Even if I am physically logged into the machine I can't log in with ssh -p 2000 user@127.0.0.1. I can ssh to and from any other machine on my network (the server can even ssh into another machine). So it isn't my network causing issues.It seems like the port 2000 is completely closed, if nmap the server's IP address I get PORT STATE SERVICE
25/tcp open smtp 80/tcp open http 110/tcp open pop3
For more than a year I was happily using my Fedora 11 remotely through VNC over ssh. I was using desktop 0 on port 5900 so people at the office can see what I am doing.
Yesterday I upgraded to Fedora 12, then 13 and then 14. I installed all updates of F14. All went well until I came to use this server from home as usual. The server was not responding.
I brought up /etc/X11/xorg.conf from a backup tape because I discovered that it is there that screen 0 is set and not in /etc/sysconfig/vncservers and rebooted. No success!
At the command lsof | grep LISTEN, I could not see a listener on port 5900
I activated screen 1 on port 5901 and I could log in OK and with lsof I could see listeners for ports 5901 and 6001 but I need screen 0!
During the day I tried many things including removing the vncserver packages with yum and re-installing them, removing the .vnc folder in the user home folder and starting from scratch. The server is still refusing connection!
i have just setup a firewall using iptables on centos 5.3 but there's an issue with ftp i can connect and i can login when i give command "ls" it says entering passive mode and afterwards it times out do you know why? i have port 21 open in my firewall but still....
sometime ago i have setup a nice Debian FTP server. and left the company. everything was working fine for about 5 month, administrator was able to login to root, do changes and manage system, etc. Suddenly he told me that he cannot login via PUTTY, the root user and pass say Access Denied.Looked all over the web for at least a REASON, but did not find anything. I suggested to go and do passwd reset, via runLevel 1. i hope this helps him. But i am still curious why all of the sudden, in a locked down room, where only one person has access root get disabled.
I'm trying to install RubyOnRails, I'm at the point of installing the gem modules mongrel, mysql and passenger Running gem install mongrel Returns
Code: Building native extensions. This could take a while... ERROR: Error installing mongrel: ERROR: Failed to build gem native extension. /usr/local/bin/ruby extconf.rb
