Uninstalling / Reinstalling MySQL
I want to completely uninstall and reinstall MySQL. However, when I unistall MySQL in the standard way, some data remains and when I re-install it retains some data from previous sessions, passwords etc and PHP cannot connect to the newly installed version.
How can I fully remove and re-install MySQL?
View Complete Forum Thread with Replies
Related Forum Messages:
Uninstalling Then Reinstalling
I am having what I hope is a very simple problem getting started with mySQL. I had the server running earlier this morning and everything seemed fine. But I had to unistall it for some reason (I can't even remember why now!) The problem is, the new installation won't work - the service won't start. It doesnt give any more information than that. I went to the services listing in Windows in order to try and restart the service manually, but as I expected, I got the same problem. Now, I know whats causing the problem - the service installed by the original install is still sitting there. I can tell because if I look at its properties, it still refers to the old installation path. Its as if the uninstaller didn't unistall the service, just everything else. Does anyone know how to fix this and why it happend in the first place. I think I just need to get rid of the service and then everything would be fine. I can't find anything to do with mysql on my computer or in the reg.
View Replies !
Reinstalling Mysql
I had mysql install from the XAMPP bundle, but was having issues with that setup, so I uninstalled and deleted all related directories. Now, when I attempt to install mysql from their distributions from mysql.com, it will not let me assign a password to the root account. The install errors out when trying to apply the security settings. The error number is 1045, saying access is denied for the root@localhost user. Also, when I attempt to use the mysql command line client, when I enter the password, the command screen just disappears.
View Replies !
Wiping MySQL And Reinstalling..
I'm trying to get rid of the mysql-standard-5.0.27-osx10.3-powerpc folder and the mysql-standard-5.0.27-osx10.4-powerpc folder in /usr/local/ but it is telling me the files are in use.. how do i fix this? I feel like I messed up somewhere along the way because I've been jumping back and forth between PHP and RoR.. I want to just start over because I feel like some things may have gotten mixed up. I wish there was an Apple +Z for the last 2 days...
View Replies !
Reinstalling Mysql On Local Machine
I had mysql install from the XAMPP bundle, but was having issues with that setup, so I uninstalled and deleted all related directories. Now, when I atmysqlt to install mysql from their distributions from mysql.com, it will not let me assign a password to the root account. The install errors out when trying to apply the security settings. The error number is 1045, saying access is denied for the root@localhost user.
View Replies !
Uninstalling MySQL 3.23.52
I am having Difficulties Uninstalling MySQL 3.23.52 . When I try to uninstall it through the Add/Remove programs I get an error messaging stating " The log file 'C:mysqluninst.isu' is not valid or the data has been corrupted. Uninstallation will not continue." I am running Windows XP if that helps.
View Replies !
Uninstalling Mysql Server
I need to uninstall an already existing server.I am trying to do that but some of the dependencies does not allow me to un install it completely. Can any one help me by giving steps i should perform to uninstall server completly and reinstall it..
View Replies !
Uninstalling MySQL Service
I have an error that pops up in a prompt saying that "(null) was compiled with ... and PHP was compiled with... They must match." I don't remember the entire pargraph and couldn't copy it so I could paste it here. But part of it was "Thread Safety-1" This window pops up 16 times with OK Only during start up of my windows XP system. I can't tell if it is related to MySQL or PHP. I have a MySQL Service running that is associtated with a non-existant directory. It is the only one. I want to uninstall the service but don't know how. Windows Service Manager (or MMC) won't let me do anything but start or stop the service. I say the MySQL is associated with that folder because when I select properties it tells me the directory. How can I uninstall this so I can make a fresh start?
View Replies !
Uninstalling MySQL On Linux
I recently manually installed MySQL on linux/fedora 5 which caused problems as MySQL is built into the the RPM. Therefore I would like to uninstall my version of MySQL and revert back to original. As I am new to Fedora can anyone point me in the right direction to help me uninstall MySQL as there does not appear to be an unistall package/function.
View Replies !
Uninstalling Mysql From Fedora Core 3
I have fedora core 3 with mysql 3.23 .Now i want to uninstall mysql 3.23 because I want to install mysql 4.1. As my very new in this field. would anybody tell me how to unstall mysql 3.23 from fedora core 3. I tried through system tool "remove software package" but could not get the result I want
View Replies !
Problems Uninstalling And Re-installing Mysql 5.0.15 On Mac OS X
Brand new Mac user trying to install mysql 5.0.15 on local machine running Mac OS X version 10.4.3. After downloading and opening mysql-max-5.0.15 package, I get the following error: "You cannot continue. There is nothing to install." Tried unistalling mysql (to see if that was the problem) using directions from http://www.entropy.ch/software/macosx/mysql/remove-old-mysql.html -- however, after running the command "mysqldump -u root -p --all-databases > mysql-dump.sq", I get the following error: "mysql-dump.sq: Permission denied" Looking for basic step-by-step direction to completely unistall mysql, in order to try re-installing mysql again.
View Replies !
ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (13)
I have a problem connecting to sql and can't find anything on the net to solve the problem. I have some sql databases running on a server. when I'm root on the server and I want to login to sql I do "mysql -ustudent -p -Dwordnet30 and it works fine. when I'm logged in with the user account on the server, i get this error message: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) so with the same user name in mysql, i can log on when i'm root, but not when i'm the user. the grant table for the user looks like this: Code:
View Replies !
Can't Connect To Local MySQL Server Through Socket '/home/data/mysql/mysql.sock' (13)
I just installed mysql on linux. If I open a terminal, su to root, then type "mysql", I am able to connect to the server and run my queries. If I exit out of su so that I am my own id (baisley) and type "mysql", I get this error: Can't connect to local MySQL server through socket '/home/data/mysql/mysql.sock' (13) Any idea why? mysql.sock has full permissions (read/write/execute), so it should be accessable by user baisley. If I am baisley and I run "mysql -u mysql" (as mysql is the user that the RPM set up), it will connect. What I would like to be able to do is run this without having to be user mysql all the time. How do I go about setting that up, or is it better to run all my queries/make tables as 1 user?
View Replies !
ERROR [HY000][MySQL][MyODBC 5.00.11][MySQL] 2006 MySQL Server Has Gone Away
Hosting Package Environment: ASP.NET ver 2 MySQL 5.0 FP Extensions 2003 Progression: Developed Website Outline Developed Database in Access2003 Migrated AccessDB to MySQL @ Hosting Service using Migration Tool. Can connect using MySQL Admin tools and run queries fine and all data, relations etc. are there. PROBLEM: (The heart of the matter) Starting simple, created GridView Control using Microsoft Visual Web Developer 2005 Express, a few glitches here and there, used the MySQL Connector/ODBC v5.00.11 followed instructions. Can see database in Database Connections Window but when I try to connect the GridView Control to it I get: "Database schema could not be retrieved for this connection. Please make sure the connection settings are correct and that the database is online. ERROR [HY000][MySQL][MyODBC 5.00.11][MySQL] 2006 MySQL server has gone away" Had thought that "Microsoft Visual Web Developer 2005 Express" might be messing with the ODBC driver so thought to download the .NET Connector. That's when it all went bad. The documentation does not say how to install or use the connector or where to put the files. It seems to assume that these bits of information are common knowledge and I suppose that if I had kept up with the technology it might be. But alas I didn't and it Isn't and It Don't work.
View Replies !
Could Not Load MySQL Driver! Compile Php --with-mysql Or Install The Mysql.so Module.
I am trying to install Media Wiki 1.5.2 on Windows XP and I have already installed apache_2.0.55-win32-x86-no_ssl ,mysql-5.0.15-win32 and php-5.1.1-Win32 . When I am trying to install Media Wiki 1.5.2 I receive the following message : Warning: dl() [function.dl]: Not supported in multithreaded Web servers - use extension=mysql.so in your php.ini in C:Program FilesApache GroupApache2htdocsmediawikimediawiki-1.5.2install-utils.inc on line 17 Could not load MySQL driver! Please compile php --with-mysql or install the mysql.so module.
View Replies !
Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (11)
We run Bitrix CMS and upon installing the web statistics module, it will sometimes show this error: Error! mysql_connect('-', '-', '-') Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11) The max connections has been raised to a 1000... and SHOW GLOBAL STATUS says for the maxed used connections: Max_used_connections 273 The server does not really max out...
View Replies !
How To Configure MySQL ODBC Driver To Connect To A Mysql Server On My Own Side Of The Router?
Using MS Access, I have attached to MySQL servers in other states and other countries on the other side of my router. But when I use the MySQL ODBC driver 3.51 to connect to a MySQL server on my own LAN, the driver tells me it cannot make the connection. Here are the ODBC driver connection parms: Data Source Name: (free field - name my "my linux box" will do nicely) Host/Server Name (or IP) - something like MSQLUserName@ServerName.net has worked fine for me in the past. Now I'm trying 192.168.1.106 Database Name - whatever, mysqldb works fine, any valid db User - root Password - myrootpass Port - 3306 has worked fine 4 me N the past. Dunno whether 2 use now SQL Command On Connect - haven't ever put anything here Perhaps there is some configuration in mysql user privilege for the mysqluser "root" that would prevent him from logging from a remote PC to the mysql server?
View Replies !
Warning: Mysql_query(): Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock' (2)
I'm trying to connect to my MySQL database (sitehosted by GoDaddy) using PHP. I am having these errors and don't understand what they mean Warning: mysql_query(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 Warning: mysql_query(): A link to the server could not be established in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 Notice: Query: SELECT * FROM types MySQL error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 here4 Warning: mysql_close(): no MySQL-Link resource supplied in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 13 I've checked paths and connection settings and don't see any problems. My guess is now that the problem is coming from the opening and closing of the DB. my script, c_register.php uses a require_once('../mysql_connect.php') to open the connection to the database. But I also have a function definition in c_register.php that uses require_once('../mysql_connect.php') when called because it needs a connection to the DB. Here's a visual that might help:
View Replies !
MySQL Error Number 2003 :: Can't Connnect To MySQL Server On 'hostname'(10065)
I was running an older version of the query browser a while back to connect to an older version of mySQL (3.0) running on a linux box. The server hasn't changed, but the query browser has been upgraded to 1.1.10. I can't go back to the older version of the query browser because the machine that ran it got re-formatted so I downloaded the new version and installed it. So ... I get the following error when I try to connect: MySQL Error Number 2003 Can't connnect to MySQL server on 'hostname'(10065) Interestingly, I wrote a simple PHP script to connect to the server and pull some data off of it:
View Replies !
Table Rows Inserted By Embeddded MySQL Cannot Be Retrieved By MySQL Tcp Client
I have encountered a weird behavoir of embedded MySQL. Through a simple program I made (in Delphi 6), I can insert rows to a table through embedded MySQL and I can retrieve the rows from my program. But using mysql.exe which points to the same table (through 127.0.0.1, with the same basedir and datadir), I cannot see the rows I inserted using my embedded program. Another way around, the rows inserted by mysql.exe can be seen in my embedded program. But after a row is inserted by mysql.exe, the rows inserted by the embedde program are deleted (or cannot be queried). Can anybody explain why is this? Is there a way to fix it?
View Replies !
DBD::mysql::st Execute Failed: Lost Connection To MySQL Server During Query
I am using perl to connect to a database and then pull the rows off of the table one by one to manipulate the data. If I use a smaller table (~8 MB), I wait for around 20 seconds but then the table values are read just fine. However if I use a larger table (~30 MB), I wait for a while and then I get the message: DBD::mysql::st execute failed: Lost connection to MySQL server during query I have tried searching for the solution to this problem and haven't found anything that helps yet. I have changed the values of 'max_allowed_packet' and 'wait_timeout', with no effect. Any ideas?
View Replies !
I Want To Make Transfer Data Between MySQL Server To MySQL Local .
I want to make transfer data between MySQL Server to MySQL Local . My Environment. Server < --- > My PC Client Server = ::::: MySQL DB Server ( for Linux ) ::::: Apache .. ::::: Linux PC Client = ::::: Window ::::: MySQL run localhost ( for window ) How i transfer data from mysql server to mysql local .? Caz i don't want to connect via 3306 port .. Can i use others way?
View Replies !
Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock'
I've installed MySQL-4.0.14 under RedHat 8, using both rpm's and compiling from source. When I try to run MySQL, I get the following error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' After much searching on Google, and reading many newsgroup threads on this error, as well as reading the manual, I'm still stumped. Most of the advice I've found suggests that the path to mysql.sock is wrong, which makes sense, but I don't have the file mysql.sock anywhere on my machine, so obviously I can't correct the path.
View Replies !
MySQL-error : Can't Connect To Local Mysql Server Through Socket
On a freshly installed Fedora C3 (incl. webserver apache php mysql) i get the following problem when connecting to mysql through a browser (phpMyAdmin):: #2002 Can't connect to local MySQL server through socket /var/lib/mysql/mysql.sock On the website of MySQL this error is mentioned but I found no solution. In /var/log/messages the following log occurs : localhost kernel: audit(....): avc: denied {write}for pid=2458 exe=/usr/sbin/httpd name=mysql.sock dev=hda13 ... What I have tried : - mysql.sock is srwxrwxrwx, seems ok, but dont know what the s stands for - the dir /var/lib/mysql was drwxr-xr-x and I changed it to drwxrwxrwx : no effect - tried different version of phpMyAdmin : same error - installed my website and got the following error : No connection possible with database (in the next version I will improve the error-messages) - through commandline there is no problem in connecting to mysql (log in, create databases, inserts, deletes, uploading dumps, making dumps, ....) What is the solution or what else can I try ?
View Replies !
Incorrect Key File For Table Error When Upgrading From MySQL 4 To MySQL 5
I have installed MySQL 5.0.67 yesterday. Previously we were using 4.0. On the development server, testing server, and training server this upgrade went smooth. The only thing I did there was run mysql_fix_privilege_tables. But yesterday, after doing this same thing on production server, something went wrong, at least with one database. While I was in the office things looked fine. But this morning I noticed error messages like: 090119 16:29:04 [ERROR] /usr/local/mysql5/bin/mysqld: Incorrect key file for table './questionnaire/answers.MYI'; try to repair it I tried: repair table answers but then I got the following error message: 090120 8:49:21 [ERROR] /usr/local/mysql5/bin/mysqld: Table './questionnaire/current_answers' is marked as crashed and should be repaired
View Replies !
How To Connect Remotely To Linux/MySQL Using MySQL Query Browser
http://dev.mysql.com/doc/query-brows...onnection.html I'm trying to connect from my Windows based PC to a dedicated server which is running on Linux system. I type server host and port 3306 user name admin + password and default schema and I get access denied message. I use putty to connect to the server using IP and port 22 and it connects to the server. What settings do I need to use to connect to MySQL using query browser?
View Replies !
Mysql Pegging One Proc To 100% Why? How To Stop Unwanted Mysql Procs
When I run top I have mysql_safe running its *** off and it is pegging one cpu core to almost 100% but the other core is sitting at 0. What is this mysql_safe? I also have a mysqld process that is doing a little at the same time but nothing like mysql_safe. I think the mysqld process may be the actual process I need. And why isn't the mysql_safe process spreading across cpu cores? When I do to /etc/init.d I find the 3 mysql's... mysql mysql ndb mysqlndb-mgm I did some searching and saw that mysql ndb is for clustering. I am not doing any clustering, this DB is about 1 GB and nothing extremely huge. Can someone explain what I can get rid of/ how I can find out what apache/php is using, how I can stop ones I don't need? I did install mysql with sudo apt-get install mysql.x.x
View Replies !
Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock' (2)
I am using a Mac running Mac OS X 10.4.8 and I have successfully installed MySQL on it but when I go to run it using the command sudo ./bin/mysqld_safe & all it does is display a random dumber and when I try the command ./bin/mysqlshow -u root -p I get an error message saying Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
View Replies !
How To Use A Copy Of A MYSQL 4.1 Database In MYSQL 5 Running On Ubuntu Linux
We had a "permanent world" game server running on an older PC, under Ubuntu 5.10, using a MYSQL 4.1 database to store persistent data for the players, then the hard disk quit. We did back up our data on a regular basis, but didn't use MYSQL to do the backups, we simply copied the MYSQL/data/ folder to disk. So now we have a new hard disk, with Ubuntu 7.10 and MYSQL 5 installed. We have everything working, in that we have created the appropriate database and, using a simple test module of our game which will create some of the tables if they don't exist in the database, we can store and retrieve data from the database tables. The problem we have is how in the world do we get the data from the backup copy of the MYSQL 4.1 created database into the new MYSQL 5 database correctly? With 4.1 we could copy the contents of the database folder right into the database folder in the /var/lib/MYSQL/ folder, but this procedure didn't work with MYSQL 5. The files seemed to copy, as in the copy operation gave no errors, but we get an error that says the database is unavailable and to make sure the MYSQL server is running - it is, so we're stumped, and our game server is offline.
View Replies !
Using MySQL 3.23 Driver With MySQL 4 (and Borland DbExpress Drivers)
I've been playing with the Borland dbExpress Drivers, and it would appear that Borland only have beta drivers for MySQL 4.x.x However it would also appear to be possible to access a MySQL v 4.x.x database using the 3.23 client libraries (i.e just get libmysql.dll from 3.23) can here see any problems in doing this? The only ones I can see is we'll loose some features such as the ability to use encrypted SSL connections.
View Replies !
Restore Mysql Databases From /var/lib/mysql/user_database/ Files Only?
I recently had a harddrive failure and luckliy I can still access certain directories on this failed drive. I can still access the /var/lib/mysql/ directory which holds all the users databases and have backed all these up separately using tar. Now what I need to know is how do you restore these database files to another server? I tried simply untar'ing one of these to the new servers /var/lib/mysql/ direcotry and it stuffed Mysql up - it went offline. I had to get a cpanel tech to bring Mysql back online.
View Replies !
Import Dump From Unix Mysql To Windows Mysql
I am trying to load a dump from a MySQL database on my ISP's server to my development environment on a Win 2K machine (running MySQL). When I run the mysql command to run the load script, MySQL gives the following complaint: "ERROR 1064 at line 21: You have an error in your SQL syntax. Check the manual t hat corresponds to your MySQL server version for the right syntax to use near 'D EFAULT CHARSET=latin1' at line 7" The dump from the ISP's server is created using mysqldump. The ISP is running MySQL 4.1.20. My development environment is MySQL 4.0.26. I have no problem loading dumps made from my development environment usng phpmyadmin.
View Replies !
Remote Connection To MySQL DB Server From Client With No MySQL DB
I have MySQL server running on a Solaris machine. I have a Perl tool that is run on multiple operating systems (Linux, Solaris, MKS on windows, CYGWIN on windows). I would like to post to the MySQL database on the Solaris machine from this script when it is run on the different local clients. All these clients share a single network share (available via Samba on windows). Is there a Perl module that I can install in the network share that I can use to connect remotely to the server DB?
View Replies !
Question Regarding MySQL Interface Options And MySQL Vs MS Access
First, there are many applications available for interacting with MySQL. One of the things that frustrated me at first was the CLI. I know that it's the foundation and understanding syntax is critical to making it all work in the end, but when dealing with large datasets, I feel that a GUI makes life easier at times. So, I started out with phpMyAdmin, seems to be 'the' geek-preferred application. I also ran into a few shareware ones here and there as well as Navicat, and I recently learned that there are 2 apps from MySQL.com for administrating the DB and creating queries. In your experience, what seems to be the best MySQL interface application? At the moment I couldn't say *exactly* what I'm looking for, but more-or-less something that will ease the headache of creating queries and managing users, tables, etc. Question #2: I have been hired to be a Web Developer, Network Admin, and Database Administrator all-in-one. We have are a retail company selling peuter goods and have a product line-up of about 100 items. The President wants a robust database to deal with everything. Right now we use MS Excel for our needs. He says it's becoming cumbersome and wants to move on. I suggested MS Access because that's exactly what it's built for, companies that have been running in Excel and want more robust control over what they're doing. But the president keeps hearing this 'MySQL' buzzword and wants a MySQL database. Fine with me, I just know Access better, that's all. I've been cramming PHP & MySQL down as fast as I can and am starting to feel more familiar with both technologies. At the moment, I feel MySQL to be more of a headache (my fault I'm sure, I just don't know it yet) But For Example: To properly normalize a DB, I sometimes have to break a table into 3 tables. The first and second are no problem, but the third 'association' table is annoying (at least doing it CLI or phpMyAdmin). See, Access, you just make 2 tables and graphically set associations very easily. So, from what you know of MySQL, do you think it would be still superior to Access seeing as we want to integrate it into osCommerce eventually and possibly some of their user contributions?
View Replies !
Error With SQL Statement When Using MySQL 5.0.24 (Works Fine In MySQL 4.0)
Here is my query that worked in mySQL 4.0 but not in MySQL 5.0.24: INSERT INTO magtallynew SET magempnum=?', magcentre='YVRRC', entrydate=��-08-15', empnum=?', empcentre='YVRRC', connection='Rockwell', service='Express', region='dom', callertype='CSR', otherdept='', transferredcall='No', directrespdept='No', station='Not Applicable', withoutmagassist='Yes', category='Accounting', issue='Advised On Contact', comments='test' Here is the error message I get: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'connection='Rockwell', service='Express', region='dom', callertype='CSR', otherd' at line 1
View Replies !
|
TRACKER
