Topic: Howto install MySql

[beeboob]

I get this:

yum install mysql mysql-server e-smith-mysql
==============================================================
WARNING: Additional commands may be required after running yum
==============================================================
Setting up Install Process
Setting up repositories
smeaddons                 100% |=========================|  951 B    00:00
smeos                     100% |=========================|  951 B    00:00
smeupdates                100% |=========================|  951 B    00:00
Reading repository metadata in from local files
Parsing package install arguments
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package mysql-server.i386 0:4.1.12-3.RHEL4.1 set to be updated
---> Package e-smith-mysql.noarch 0:1.12.0-01 set to be updated
---> Package mysql.i386 0:4.1.12-3.RHEL4.1 set to be updated
--> Running transaction check
--> Processing Dependency: mysql-client for package: MySQL-test-standard
--> Processing Dependency: perl-DBD-MySQL for package: mysql-server
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package perl-DBD-MySQL.i386 0:2.9004-3.1 set to be updated
--> Running transaction check
--> Processing Dependency: mysql-client for package: MySQL-test-standard
--> Finished Dependency Resolution
Error: Missing Dependency: mysql-client is needed by package MySQL-test-standard
================================================================
No new rpms were installed. No additional commands are required.


But what is the mysql-client I can not find any thing about it??

[beeboob]

It is are hard job this one...

is it better just to give up or??? I have use so many hours on this whit no result. It is not nice...

[pfloor]

It is are hard job this one...

is it better just to give up or??? I have use so many hours on this whit no result. It is not nice...

It loos like you have installed some Non-Standard packages.  Do you know EXACTLY what you did or even why you did it?

let's see what you might have that doesn't belong:

rpm -qa *My*

Paul

[beeboob]

I dont know EXACTLY,

But i try this

1. yum install e-smith-mysql

2. signal-event post-upgrade

3. signal-event reboot

4. rpm -qa *my*

And get this

MySQL-client-standard-5.0.19-0.rhel4
MySQL-test-standard-5.0.19-0.rhel4
MySQL-server-standard-5.0.19-0.rhel4
MySQL-devel-standard-5.0.19-0.rhel4
MySQL-standard-debuginfo-5.0.19-0.rhel4
MySQL-shared-compat-5.0.19-0.rhel4
MySQL-shared-standard-5.0.19-0.rhel4

[beeboob]

Is this good???

So i want to try to go to mysql..

I try

mysql

and get

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

So now i have are new problem  

[pfloor]

I dont know EXACTLY,

But i try this

1. yum install e-smith-mysql

2. signal-event post-upgrade

3. signal-event reboot

This won't work because you have extra packages installed that should not be there.  It looks like you tried to install mysql5.  Don't try things like this if you don't know what you are doing.  Adding and upgrading packages on SME is dangerous...DON"T DO IT!!!

4. rpm -qa *my*

And get this

MySQL-client-standard-5.0.19-0.rhel4
MySQL-test-standard-5.0.19-0.rhel4
MySQL-server-standard-5.0.19-0.rhel4
MySQL-devel-standard-5.0.19-0.rhel4
MySQL-standard-debuginfo-5.0.19-0.rhel4
MySQL-shared-compat-5.0.19-0.rhel4
MySQL-shared-standard-5.0.19-0.rhel4

These all must be removed on at a time.  Try this:

rpm -e MySQL-client-standard-5.0.19-0.rhel4
rpm -e MySQL-test-standard-5.0.19-0.rhel4
rpm -e MySQL-server-standard-5.0.19-0.rhel4
rpm -e MySQL-devel-standard-5.0.19-0.rhel4
rpm -e MySQL-standard-debuginfo-5.0.19-0.rhel4
rpm -e MySQL-shared-compat-5.0.19-0.rhel4
rpm -e MySQL-shared-standard-5.0.19-0.rhel4

You might have to use the --nodeps option for this like

rpm -e --nodeps MySQL-client-standard-5.0.19-0.rhel4

[pfloor]

STOP trying things.  You need to do this a step at a time or you will get nowhere.

Trying things without knowing what you are doing is how you messed your server up in the first place.

[beeboob]

Thanks...

I have done it now...

Do you now, what to do now

[beeboob]

root@server ~]# rpm -qa *my*

php-mysql-4.3.9-3.9

e-smith-mysql-1.12.0-01

[pfloor]

Now try to install mysql4 back onto your system like this:

yum install mysql mysql-server e-smith-mysql

It should ask you if you want to install 3 or 4 packages, answer yes.

Then finish with:

signal-event post-upgrade
signal-event reboot

Paul

[beeboob]

Nice...

I try it now....

[beeboob]

yeeeeeeeeeeeeeeeeeeeeeeeees:::: Try and look:::::

yum install mysql mysql-server e-smith-mysql
==============================================================
WARNING: Additional commands may be required after running yum
==============================================================
Setting up Install Process
Setting up repositories
smeaddons                 100% |=========================|  951 B    00:00
smeos                     100% |=========================|  951 B    00:00
smeupdates                100% |=========================|  951 B    00:00
Reading repository metadata in from local files
Parsing package install arguments
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package mysql-server.i386 0:4.1.12-3.RHEL4.1 set to be updated
---> Package mysql.i386 0:4.1.12-3.RHEL4.1 set to be updated
--> Running transaction check
--> Processing Dependency: perl-DBD-MySQL for package: mysql-server
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Package perl-DBD-MySQL.i386 0:2.9004-3.1 set to be updated
--> Running transaction check

Dependencies Resolved

=============================================================================
 Package                 Arch       Version          Repository        Size
=============================================================================
Installing:
 mysql                   i386       4.1.12-3.RHEL4.1  smeos             2.8 M
 mysql-server            i386       4.1.12-3.RHEL4.1  smeos             6.7 M
Installing for dependencies:
 perl-DBD-MySQL          i386       2.9004-3.1       smeos             111 k

Transaction Summary
=============================================================================
Install      3 Package(s)
Update       0 Package(s)
Remove       0 Package(s)
Total download size: 9.6 M
Is this ok [y/N]: y
Downloading Packages:
(1/3): mysql-server-4.1.1 100% |=========================| 6.7 MB    01:01
(2/3): perl-DBD-MySQL-2.9 100% |=========================| 111 kB    00:01
(3/3): mysql-4.1.12-3.RHE 100% |=========================| 2.8 MB    00:25
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing: mysql                                                  [1/3]warning: /etc/my.cnf created as /etc/my.cnf.rpmnew
  Installing: mysql                        ######################### [1/3]
  Installing: perl-DBD-MySQL               ######################### [2/3]
  Installing: mysql-server                 ######################### [3/3]

Installed: mysql.i386 0:4.1.12-3.RHEL4.1 mysql-server.i386 0:4.1.12-3.RHEL4.1
Dependency Installed: perl-DBD-MySQL.i386 0:2.9004-3.1
Complete!
==============================================================
WARNING: You now need to run BOTH of the following commands
to ensure consistent system state:

signal-event post-upgrade; signal-event reboot

You should run these commands unless you are certain that
yum made no changes to your system.
==============================================================

[pfloor]

Looks good so far...

DON"T FORGET THIS:

signal-event post-upgrade
signal-event reboot

Paul

[beeboob]

The server have just restart...

Is there are next step... Something i have to do, so i can test it is running... And want about the root password for the mysql server... Is that ok..

[pfloor]

The server have just restart...

Is there are next step... Something i have to do, so i can test it is running... And want about the root password for the mysql server... Is that ok..

The root password is automatic and should be set by the system.  try to log into mysql first and see what happens:

mysql

If it gives you a password error, I can give you the steps to fix that.

Paul