Topic: Howto install MySql

[beeboob]

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

[pfloor]

Here is how to reset the password:

cd /service/mysqld
runsvctrl d .
cat set.password | /usr/libexec/mysqld --bootstrap \
  --user=mysql --skip-grant-tables
runsvctrl u .

Try loging in again.

If you find that webmail does not work then you need to re-initialize mysql and all the underlying systems.

CAUTION!!! The commands BELOW will delete any databases and return the server to it's original configuration. CAUTION!!!

cd /service/mysqld
runsvctrl d .
/etc/e-smith/events/actions/mysql-delete-db-files
signal-event post-upgrade
signal-event reboot

[beeboob]

Ok,, i will try the first one..

And hope that i not have to use

cd /service/mysqld
runsvctrl d .
/etc/e-smith/events/actions/mysql-delete-db-files
signal-event post-upgrade
signal-event reboot

[beeboob]

This is the best,,,, So many, many thanks... Try and look. It so great,,,, uhhh nice    My head...

]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.12

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>


Try and look, i come in to, mysql. Jubbbbbbiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii

[beeboob]

I hope this i ok...

I get the fil

smeserver-phpmyadmin-2.6.4-pl4.dmay.noarch.rpm

then go to the folder, That have the file.. I use just cd /tmp

rpm -Uvh smeserver-phpmyadmin-2.6.4-pl4.dmay.noarch.rpm

And i come in the PhpMyadmin control panel via:

https://server1/phpmyadmin/

Nice. and many, many thanks.

[gregswallow]

How to install the newest 4.x of mysql or bette howto install Mysql 5.0

This 3 page story is a perfect example of why you shouldn't upgrade components that are in SME7.  SME uses the CentOS rpms because Redhat and CentOS will provide security updates for mysql and php, etc, until 2012.  "Because it's there" may be a good reason to climb Everest, but not a good reason to install the newest mysql 4.x or 5.

[beeboob]

Yes it is right. Never do that.

It is very stupid.. Newver just trust are howto. Next time i have to follow are HowTo, i am looking in the forum first..

[MSmith]

Wouldn't it have been simpler to just install a fresh copy of SME Server?  I understand wanting to try out various CRM/ERP packages but why not start fresh with each one?