Ubuntu :: Reinstall MySQL (and PHPmyadmin) From A Completely Clean Slate?
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)
I'm attempting to install some software on my friend's computer. It keeps saying the packages I want aren't there but I know they are. I've been fooling around with this for a while. I may have broken something in the process. Repository names, perhaps?Is there some way to reinstall Synaptic/Aptitude and "wipe the slate clean?"
I need to wipe the slate clean on my computer and start from scratch. I have too many issues and school is just around the corner for me, I've got a huge workload and don't have time to find solutions to my problems right now. I recently upgraded to Lucid but that only escalated my woes. The simple fact is my machine is getting too old and it's time to upgrade everything, which won't happen until fall. So for now I simply want to downgrade to hardy because it will be supported until April next year and it is very stable, plus I think it is the release that my graphics card got a decent resolution on (ATI, need I say more?). I'm somewhat of a noob, but I've got my wits about me and have researched the forums for many hours to find solutions, but to no avail. I don't want to go into details about what issues I'm having, I just need to know how to remove ALL kernels off of Grub and start from scratch. Any links to comprehensive tutorials would be ideal, or if someone knows of anything else that will work,
P.S. I love Ubuntu and am a lifer. The philosophy behind it as well as the community are supreme and will someday rule the universe,
I have followed instructions here to install apache + php5 + mysql
[URL]
Apache 2 server is working. phpinfo.php shows php working. I've previously installed phpmyadmin .. but this time I've made some error in installing phpmyadmin. I would like to start afresh .. remove and reinstall. I looked in Synaptic Package Manager and phpmyadmin had a green marker .. showing installed. I tried "Mark for complete removal" But I can't purge phpmyadmin installation to try again. See screenshot.
I'm running it on a Toshiba Satellite laptop.After getting the OS installed and configured evolution, I did a backup of the evolution on my desktop version of 10.04 and attempted to restore it to evolution on my laptop and while it did seem to work, it became corrupted and now won't load.
I uninstalled multiple times and reinstalled to get the same problem. I also removed a number of folders trying to get a clean install but ran into the same problem as soon as restored again.How can I completely remove evolution so that I can get a truly clean install where the wizard comes up for set up again once I open it for the first time?
I'm trying to get Samba running, but I accidentally deleted smb.conf. I tried reinstalling Samba through apt-get, but it does not create another smb.conf (which it did when I first installed it). I'm pretty new to ubuntu, and I'm just wondering if anybody knows how to get a completely clean install.
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 uninstalled Chromium including config files through synaptic, but then after doing a file search, I found lots of Chromium and Chrome files laying around. So then I used that search list to delete them, but I believe there are still Chromium/Chrome files somewhere on my Ubuntu 9.10.To regress a bit and for a little background on this problem, I wanted to uninstall Chromium because I want to see if I can correct this problem that I have with the browsing history file. I want the browse history feature to work and it doesn't - the archive has all of the activity from only one day in history, 8 Apr 2010, and when I try to delete that day of history, it says that is has been deleted, but it is still there, and it won't record any of my browse history.
So I thought if I could do a clean install from scratch, maybe I could get the history feature back.Anybody know where I can find the file containing the history files and/or tell me how to clean reinstall of Chromium?
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 have debian on a VPS. I think the installation is fubar.
Can I completely reinstall debian on this? I don't suppose I need to format the disk. Could I put some sort of network install is some special directory, and run the install from that?
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..
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.
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?
So in essence, my drive has become a cluster of random partitions, multiple Ubuntu installs, and random windows systems. It's gotten so bad that on my entire 250gb system my main Ubuntu install only gets 40gb of memory. Could anybody give me a step by step guide to do the following:
1. Completely wipe and departition my disc. 2. Install Ubuntu from a backup .tar file 3. Install a 40gb windows 7 partition
After two years worth of trying to get HDMI audio working on, what should be, a MythTV box I am now fed up to the teeth with it. Utterly, completely sick and dissilusioned with Ubuntu & HDMI. Firstly there is no problem with the hardware as I managed to get HDMI audio working using the original install of 9.04. However the sata DVD drive didn't work. So I waited until 10.04 and upgraded after which the DVD drive worked but HDMI audio didn't. So after a couple of months worth of trying everything I could find in forums etc. I gave up and waited for 10.10.
Months later and after installing 10.10 not only does HDMI audio not work but the soundcard details shown in "gnome-volume-control" now only lists a single analogue device whereas running from a 10.10 live CD I get a comprehensive list of available devices including entries SPDIF and HDMI. It's therefore obvious that something I've done in the huge list of things that I've changed has screwed up the audio configuration. And despite having reams of notes I'm in no position to find out exactly what as a) I'm not an expert in Linux audio (nor do I want to be) and b) there have simply been too many changes for me to keep track of.
how can I completely remove *ALL* traces of the current audio system and reinstall *EVERYTHING* related to audio using the latest versions ? I want to completely obliterate the current audio installation (including all configuration files, kernel headers, drivers, alsa, the wretched pulse audio etc. etc.) and start from scratch. I have already been through every sinlge HDMI related forum post and have tried everything so please don't suggest "make sure HDMI audio is unmuted in alsa-mixer" etc. as I've been there, tried that and am bored with it all. I want to completely nuke the audio system from orbit and start again. At this point I should say that I've already tried the following which didn't make any difference:
And to prove that the device is there here's the output from "aplay":
aplay -l **** List of PLAYBACK Hardware Devices **** I: caps.c: Limited capabilities successfully to CAP_SYS_NICE. I: caps.c: Dropping root privileges.
[code]....
Or should I just give up and install Windows media centre ? Having preformed a trial installation of Windows on a seperate disc everything "just works" with perfect HDMI audio, perfect picture, DVB card working perfectly, DVDs Playing etc. etc.
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' .
Currently, dual boot is working and both OSes are working as expected (although there's that bit of inconsistency with intel 845 graphics). I want to do two things in a major re-install: move Home to a new, separate partition, and do a clean 10.4 install while still retaining XP dual boot. If possible leave sda1 untouched, but that can be reinstalled if necessary.
Only things in Home that need to be moved are documents and mozilla seamonkey prefs and emails. Those items I can save and restore manually, so I have no problems with backup needed files, then clean install, then manually restore.
I know enough to be willing to try suggestions, but also know enough to recognize I can get into trouble. So that's why I'm asking here first.
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 was having a problem where I had run keytool to generate a key but had entered some bad info. I tried to run it again but it said there was already a key, so I deleted keystore thinking it would regenerate itself. I ran the keytool command again but it says it can't derive the signature algorithm.
Anyway, I've tried to 'sudo apt-get remove sun-java6-jdk' then 'sudo apt-get install sun-java6-jdk' but it doesn't seem to put me back where I was from step 1. 'sudo dpkg-reconfigure' also doesn't seem to fix it. I think if I can completely reinstall jdk then I'll be good, but how?
I just uninstalled, did 'sudo apt-get clean sun-java6-jdk' then installed again. Still get the error: keytool error: java.lang.Excpetion: Cannot derive signature algorithm
I've installed open suse with no problems however I accidentally put my root folder on an external HD. I want to have my root on a partition of my main drive so I can continue to dual boot windows. Is there a way to move root so I don't have to completely reinstall and set up all my packages and stuff again.I assume to do this I need to use the installation disk again and fix it before boot up but should I partition my main drive first. I'm being intentionally cautious as there is data I'd rather not lose on there.
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".
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
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)"
I soon found out that Suse 11.1 would no longer boot from boot.ini (using bootpart) because the boot process now brings up PCLOS (in /dev/sda6) rather than Suse 11.1 sitting in /dev/sda5. No problem, I thought, I'll boot from the Suse install DVD, use repair, and away I go. Wrong. After grinding, it started mentioning about generating something for sda13, which is my last partition. NTFS! So I bailed before it got too far. I even tried "rescue" option on the DVD, command prompt, and grub commands to reinstall via "setup.
Then I tried to use Super Grub Disk (.97xx) to reinstall the PBR, stage 1 and stage 2 loaders. Didn't change a thing. So then I used Grub4DOS and got into my Suse 11.1 installation using this in its menu.lst: title openSUSE 11.1 - 2.6.27.45-0.1
[Code]...
Worked fine, and is now my (only) method of booting to 11.1. So obviously it's bypassing stage 1 and 2 files, using it's native Grub4DOS code. But then I tried Yast-Bootloader to reinstall Grub's files. No difference. Then I used the advanced part to "write bootloader code to disk" No difference. Even tried "propose a new boot scheme" (or whatnot) no difference. After looking at all this, I've come to the conclusion that the PBR code in sda5 is scraunched, and/or stage 1 code (although it's still the original date), or stage 2 (which definitely had a new timestamp of when I committed the fatal error by executing PCLOS's "install.sh".
So my question is this: How do I do a good COMPLETE re-install of Suse's version of the grub files? Because, for sure, grub commands like "setup --stage2=/boot/grub/stage2 (hd0,5), and variations thereof, certainly aren't doing it? My reasoning is that I should make sure that all the boot files get restored/confirmed as "originally installed by Suse".
I use slackware 13.1-current on desktop with 4gb ram, nvidia geforce 210, and AMD cpu. I have problem with my X starting using 40-50 MB of RAM and after some hours suddenly rises up to 400-500 MB. I have tried KDE ( with and without desktop effects ), LXDE, 3 different nvidia drivers ( the one made from the slackbuilds ) but no luck. I decided at last to use the default slackware's driver. I uninstalled the nvidia driver and do startx, but it says code...
I have no idea about GPU and drivers, it was a mistake to install a driver for my nvidia just to have desktop effects. I just want to bring the things back as at the beginning of the systems installation and the default drivers. Do you have any idea how to do it?