installing mySQL on solaris 10 x86
 

any advice on this?


I download mysql5 ( CSWmysq ) from blastwave and can't seem to get the
server going.

i get this,
log file says nothing, useful or the Sun message.
i tried various install_db (as root) and the db_test thig was ok.


I then noticed that solaris comes with it already, as SUNWmysql.

any advice?

should I remove the new one or run with it?


postgres was easy :(

got it,
here

mysql_install_db --user=mysql

Hi, bigearsbilly


1> ============= Taken from your post =================
See: /var/svc/log/network-cswmysql5:default.log
Impact: This service is not running.

==> So, what /var/svc/log/network-cswmysql5:default.log says,
tail -10 <svc_log> to show me even though you said it is not useful

2> As you said, mysql comes with solaris also, but no needs to remove these
mysql SUNW packages, I running another mysql5 on my soalris10 without any problem.

mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.33-standard-log Source distribution

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

mysql>


3> can you run the following command to see what SMF controlls your mysql service. I remember the default mysql for soalris10 is version4
and should be controller by /etc/rc3.d/S##mysql script. I am not sure where is your cswmysql5 from. Did you install mysql5 via blastwave?


# svcs -a | grep mysql


4> mysql_install_db --user=mysql is based on the mysql version on your Soalris OS, I am running sun coolstack as follows.

# /opt/coolstack/mysql_32bit/bin/mysql_install_db --user=mysql
Installing all prepared tables
Fill help tables

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/opt/coolstack/mysql_32bit/bin/mysqladmin -u root password 'new-password'
/opt/coolstack/mysql_32bit/bin/mysqladmin -u root -h SB100 password 'new-password'
See the manual for more instructions.

NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the /opt/coolstack/mysql_32bit/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd /opt/coolstack/mysql_32bit ; /opt/coolstack/mysql_32bit/bin/mysqld_safe &