Moving the mysql database to a different server

Actually, I think by default it uses the mysql root account with no password on OS X Server and you have to set a mysql root (different from system root) password.

So, just try mysql -u root -p

Then hit enter to keep the password blank or try entering a password for the mysql root user if one was set.

So you're saying they were just trying to keep me honest…nice

:)

~Ryan

I do see an account in that database called jamfsoftware. Also I'm looking
for where to point the JSS at a different database server.

The database is called jamfsoftware...

this is my JSS, and I use default installs

s001-casper:~ root# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 9298 Server version: 5.0.67-log Source distribution

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

mysql> show databases ; +--------------------+ | Database | +--------------------+ | information_schema | | jamfsoftware | | mysql | | test | +--------------------+ 4 rows in set (0.00 sec)

mysql>

The user name you want is the mysql root user as it can administer the
database

Ok, think I found it... In /Library/Tomcat/conf/server.xml there is
information about how it connects to mysql. It shows the user
'jamfsoftware' and the password in this file. In mysql, you can see that
jamfsoftware is a user.

Looks like you may be able to change the mysql server from here as well.
There are a few variables called 'jdbcUrl' that point at the local server's
mysql database.

Hmm, dumpped the database to a new sql server box and can connect to it over
the network fine. However, the tomcat apps don't start properly after
editing /Library/Tomcat/server.xml I have contacted support to see if
they have any pointers... Maybe there are other files that need to be edited
in order to get this working.

.