about mysql problem

[frankie328]

i installed DA in RHEL4.0 OS
how can i change the mysql default character?
and i can't find my.cnf in /etc

thx~~

 

[max2000]

my.cnf doens't exist by default, you need to create it if you want to change you mysql setting or to optimise it.

 

[frankie328]

have any other ways to change the default charset???
thx~~

 

[frankie328]

have one question is
DA default set mysql root password is what???

thx~~

 

[jmstacey]

/usr/local/directadmin/conf/mysql.conf contains the username and password that DirectAdmin uses for the superuser account. Root password is usually the same as what was originally installed. Thus it should be the same as in that .conf file unless you have changed it since installing DirectAdmin. If that's the case you need to read the setup.txt file located in /usr/local/directadmin/scripts I believe but I would have to check.

 

[frankie328]

thank you very much
the password problem is fix ~~

but have any other ways to change the default charset???

 

[jmstacey]

You can recompile MySQL --with-charset=CHARSET

Those are your options.

 

[frankie328]

i want to change some mysql setting
but why i can't find my.ini too ???

thx~~

 

[resolveit]

i want to change some mysql setting
but why i can't find my.ini too ???

thx~~

You won't find my.ini on *nix server, the ini extention is used for windows machines.

To customize mysql settings on you *nix server edit/create the file called /etc/my.cnf , when you've finished changing the settings save the file and restart mysqld.

 

[frankie328]

i don't know how to recompile mysql
can anyone can help me ???

 

[max2000]

Hi

mySQL is quite difficult to recompile if you are a begginer specially on a productive machine.

You should hire some tech to do it for you.