Log inUsernamePassword
Log me on automatically each visit    
Register
Register
Log in to check your private messages
Log in to check your private messages
SMS Forum Index » SMS User Support

Post new topic   Reply to topic
mysql
View previous topic :: View next topic  
Author Message
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Mon Sep 10, 2007 6:51 am    Post subject: mysql Reply with quote

Ofcourse everything works if I don't change anything. However, if I name the host server1.cliqn.com and type 'mysqladmin -h server1.cliqn.com -u root password' that command fails.

I get an error message 'Host sever1.cliqn.com is not allowed to connect to this MYSQL server'.

What dumb thing am I doing? Do I need to do some grant command?

This also reminds me to ask about how to change host name of other servers to match 'server1'. Just trying to learn how to customize to fit schools network.

thanks
Back to top
View user's profile Send private message
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Mon Sep 10, 2007 6:55 am    Post subject: Reply with quote

I forgot one other issue: In web menu, click on MYSQL server and under Global Options select MYSQL - I get this error message 'can't find my.cnf on system'.

How do I fix this?

thanks
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1757
Location: Greece

PostPosted: Mon Sep 10, 2007 7:22 am    Post subject: Reply with quote

Most servers listen to hostname, so if you edit hostname and hosts in /etc/ I believe you are covered... Try to change those files first and run mysql command after that...

You will find in /etc/ those files:
my-huge.cnf
my-large.cnf
my-medium.cnf
my-small.cnf
choose what is most appropriate for your system (depends on RAM) and copy it to my.cnf.
I didn't set a default, I'll will though, skipped my attention.
Thanks for that

gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
baboo
Senior Member


Joined: 04 Sep 2007
Posts: 676

PostPosted: Mon Sep 10, 2007 2:24 pm    Post subject: Reply with quote

thanks. Let me make sure I understand. In my /etc directory I have no my.cnf but I do have those other files.

So, I would pick one and copy to my.cnf, thereby creating that file?

regards and Good afternoon
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1757
Location: Greece

PostPosted: Mon Sep 10, 2007 3:36 pm    Post subject: Reply with quote

Yes...
Simple as 'cp my-large.cnf my.cnf'

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    SMS Forum Index » SMS User Support All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum

SMS - Superb! Mini Server Project © 2016
Powered by phpBB © 2001, 2002 phpBB Group
iCGstation v1.0 Template By Ray © 2003, 2004 iOptional