MySQL Problem!!!

uiuiui172 · 07-07-2009, 03:05 PM

Whenever i try to get and install mysql server 5.0 on ubuntu 9
this is what appears:

Code:

dylan@dylan-server:~$ sudo apt-get install mysql-server
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following extra packages will be installed:
  mysql-server-5.0
Suggested packages:
  tinyca mailx
The following NEW packages will be installed:
  mysql-server mysql-server-5.0
0 upgraded, 2 newly installed, 0 to remove and 0 not upgraded.
Need to get 0B/23.6MB of archives.
After this operation, 79.5MB of additional disk space will be used.
Do you want to continue [Y/n]? y
Preconfiguring packages ...
(Reading database ... 124125 files and directories currently installed.)
Unpacking mysql-server-5.0 (from .../mysql-server-5.0_5.1.30really5.0.75-0ubuntu10.2_i386.deb) ...
Aborting downgrade from (at least) 5.1 to 5.0.
dpkg: error processing /var/cache/apt/archives/mysql-server-5.0_5.1.30really5.0.75-0ubuntu10.2_i386.deb (--unpack):
 subprocess pre-installation script returned error exit status 1
Selecting previously deselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.1.30really5.0.75-0ubuntu10.2_all.deb) ...
 * Stopping MySQL database server mysqld                                 [ OK ] 
Errors were encountered while processing:
 /var/cache/apt/archives/mysql-server-5.0_5.1.30really5.0.75-0ubuntu10.2_i386.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

How do I fix it?

Tinkster · 07-07-2009, 03:13 PM

Hi,

Welcome to LQ,

And why do you want to downgrade in the first place? Chances
are you'll break stuff if you succeed.

Cheers,
Tink

uiuiui172 · 07-08-2009, 12:03 PM

What?

Tinkster · 07-08-2009, 12:25 PM

Quote:

dylan@dylan-server:~$ sudo apt-get install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
mysql-server-5.0
Suggested packages:
tinyca mailx
The following NEW packages will be installed:
mysql-server mysql-server-5.0
0 upgraded, 2 newly installed, 0 to remove and 0 not upgraded.
Need to get 0B/23.6MB of archives.
After this operation, 79.5MB of additional disk space will be used.
Do you want to continue [Y/n]? y
Preconfiguring packages ...
(Reading database ... 124125 files and directories currently installed.)
Unpacking mysql-server-5.0 (from .../mysql-server-5.0_5.1.30really5.0.75-0ubuntu10.2_i386.deb) ...
Aborting downgrade from (at least) 5.1 to 5.0.
dpkg: error processing /var/cache/apt/archives/mysql-server-5.0_5.1.30really5.0.75-0ubuntu10.2_i386.deb (--unpack):
subprocess pre-installation script returned error exit status 1
Selecting previously deselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.1.30really5.0.75-0ubuntu10.2_all.deb) ...
* Stopping MySQL database server mysqld [ OK ]
Errors were encountered while processing:
/var/cache/apt/archives/mysql-server-5.0_5.1.30really5.0.75-0ubuntu10.2_i386.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

That. It really pays to read error messages.

Cheers,
Tink

uiuiui172 · 07-09-2009, 01:19 AM

I had the same problem with 5.1!

apt-shawn · 07-09-2009, 03:43 PM

uiuiui172,

What he is trying to say is you already have MySQL 5.1 installed. Have you been using it (do you have data stored in it?).

Shawn

uiuiui172 · 07-10-2009, 11:56 AM

ok. I fixed that problem but now when I type in "mysql" it says "Access denied for user 'dylan'@'localhost' (using password: NO)"

apt-shawn · 07-10-2009, 12:25 PM

uiuiui172,

Try this:

Code:

LOGIN AS ROOT:
mysql -u root -p

SEE IF YOU EXIST:
USE user;
SELECT name FROM user;

IF YOU DON'T SEE "dylan" IN THAT QUERY DO:
GRANT ALL PRIVILIGES ON [database name here].* TO 'dylan'@'localhost' IDENTIFIED BY '[password here]';
Note: You can also list which privileges you want to give too...refer to the MySQL documentation on what they are.

OTHERWISE TYPE:
exit;

THEN TRY:
mysql -u dylan -p

AND PUT IN YOUR PASSWORD.

Keep in mind this is the non-graphical client to MySQL. Check the user guide over at: www.mysql.com or refer to a MySQL book on how to use it.

Let me know if that helps.

Shawn

Wim Sturkenboom · 07-10-2009, 01:05 PM

Quote:

Originally Posted by apt-shawn

Code:

SEE IF YOU EXIST:
USE user;
SELECT name FROM user;

Suppose that that must be

Code:

SEE IF YOU EXIST:
USE mysql;
SELECT name FROM user;

apt-shawn · 07-10-2009, 02:36 PM

Quote:

Originally Posted by Wim Sturkenboom

Suppose that that must be

Code:

SEE IF YOU EXIST:
USE mysql;
SELECT name FROM user;

Indeed! Thank you

Don't have access to MySQL at work and was too lazy to take the trip to the docs myself :P

Thanks again,

Shawn