Ubuntu Servers :: Noob: Installing Phpmyadmin And MySQL?
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
ADVERTISEMENT
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
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
View Related
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
Code:
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
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
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
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
Jun 7, 2011
i am using ubuntu 10.10. I had installed apache2 and subversion, using webdav, as described in the unbuntu wiki. SVN was working as expected, I could commit files, etc. I then installed php5 and mysql, as described in the ubuntu wiki, and i now get the following on apache restart:
apache2: Syntax error on line 203 of /etc/apache2/apache2.conf: Syntax error on line 2 of /etc/apache2/mods-enabled/dav_svn.load: Cannot load /usr/lib/apache2/modules/mod_dav_svn.so into server: /usr/lib/libgssapi_krb5.so.2: symbol krb5_authdata_context_copy, version krb5_3_MIT not defined in file libkrb5.so.3 with link time reference Action 'configtest' failed.
View 4 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
Nov 15, 2010
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)
View 1 Replies
View Related
Oct 3, 2010
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".
Here is similar case with no solution [URL]
View 1 Replies
View Related
Dec 29, 2008
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
[code].....
View 18 Replies
View Related
May 13, 2010
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)"
View 2 Replies
View Related
Jan 22, 2010
finnaly i can run my ubuntu server 9.04 well, thnx to this great member of ubuntuforums.org now, i wanna i wannna install SNMP on my system, but after i do that, when i wanna connect with another client, it give me error like this :
Code:
no response received
SNMPv1_Session (remote host: "10.100.7.179" [10.100.7.179].161)
community: "public"
request ID: 862383236
PDU bufsize: 8000 bytes
[Code]...
10.100.7.179 is my client, i allready install snmp agent on it. but why still eror then? plz give some help. thnx before
View 1 Replies
View Related
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
Sep 18, 2010
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
View 4 Replies
View Related
Jun 7, 2011
Is the term a 'simple SMTP relay' a contradiction in terms?!I have an elderly Dell server on which I have just made a fresh install of 10.04 LTS server. I had 8.04 running on it for a long time, but I haven't tried an SMTP server before. It is a headless server with CLI (no GUI) and the latest version of Webmin installed.I have a basic LAMP server installed for a few websites using PHPbb and Joomla, and also I run a Mediatomb server for our household. When I installed I also chose to install mail services, but these remain masked behind NAT at the moment
I now want to set up an SMTP relay server so when I am working away and using different wifi points or my notoriously unreliable 3G dongle I can always send emails through the home server (from my iPhone and my laptop) rather than having to look up the SMTP server for each ISP of the place where I am working.
What I want is an authenticated server which takes my email and redirects it to my home ISP's SMTP server. I need only 3 authenticated users to have access (myself, my wife and my son). I don't need (or want) any incoming mail services at all.
Useful modules installed are: Dovecot, Postfix, Procmail mail filter, PAM - but how do I set them up?
Is there any simple setup that I could do, preferably through Webmin, but I can handle CLI if necessary?
I have looked at the Ubuntu help pages, but it looks so complicated to set up something that seems like it should be so simple to me.
View 9 Replies
View Related
Jul 19, 2010
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.
View 9 Replies
View Related
Aug 3, 2011
Since the upgrade to server 11.04 from 10.10 I cannot install PHPMyadmin
I keep getting error package PHPMYADMIN has no installation candidate.
View 2 Replies
View Related
Mar 9, 2010
I am trying to install phpMyAdmin using ssh (I use putty to connect to my Virtual Private server from my windows home computer)
I have managed to download the latest phpMyAdmin from sourceforge and I have renamed it to phpMyAdmin.tar.gz
Now I don't know how to install it. I have tried "apt-get install phpMyAdmin.tar.gz" but that gives me:
Reading package lists... Done
Building dependency tree... Done
E: Couldn't find package phpMyAdmin.tar.gz
So I assume I should not use apt-get
[Code]....
View 14 Replies
View Related
Sep 6, 2010
I had the brilliant idea to make my own web server since i had a silicon mechanics 1u server collecting dust. Ive got apache running. Phpmyadmin is installed but i cant get into the admin panel. When it asks for the user name and password no matter what i use it wont let me log in.
View 2 Replies
View Related
Mar 18, 2010
Have basic LAMP setup on 9.10 box. I want to have a publicly accessible website AND I want to have phpmyadmin available. The only thing is I would rather not have the phpmyadmin interface available on the internet. I usually open a ssh port forwarded tunnel when I need to use phpmyadmin on this server. I want to add a directive to make phpmyadmin bind only on localhost. I have found the phpmyadmin config file in /etc/apache2/conf.d
phpmyadmin.conf -> ../../phpmyadmin/apache.conf
I have tried adding some LISTEN directives, but apache does not like my directives-- I am obviously not doing it right. I have looked for a bit on the internet and can't find out how to disable external access to a configured site in Apache.
View 2 Replies
View Related
Jul 17, 2010
I am trying to install mcrypt for use in phpMyAdmin but am having some trouble. I apt-get'd the mcrypt-php5 package and it installed, but it seems to only function on the Apache Module version of php5 and not the CGI version. Both versions show the mcrypt extension installed in phpinfo, but in phpMyAdmin only one of them removes the error about mcrypt. Other extensions (such as cURL) which I installed with apt-get have worked, so I'm not sure why this one does not.
EDIT: I also compared the CGI php.ini and the apache2 php.ini and there were no differences there. I also confirmed that the php.ini file for the CGI version is loading from that location.
View 1 Replies
View Related
Jan 26, 2011
My situation I recently installed Ubuntu 10.04 LTS Server on a virtual machine. I installed apache2, php and mysql-server. Several vhosts I sat up are running fine and I can also connect to the MySQL server using the mysql command-line client. I now want to setup PhpMyAdmin to allow the vhosts owners to administrate their DBs. I installed the package using:
Code:
apt-get install phpmyadmin I answered the questions and accepted the creation of the phpmyadmin database. The install finished successfully. I did a small modification to the main website vhost to access it easily:
Code:
Alias /phpmyadmin /usr/share/phpmyadmin
[Code]...
View 1 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
Jun 17, 2010
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
View 1 Replies
View Related
