Koozali.org: home of the SME Server

Obsolete Releases => SME Server 7.x => Topic started by: a55830 on September 04, 2006, 07:05:50 PM

Title: MySQL server on SME 7.0
Post by: a55830 on September 04, 2006, 07:05:50 PM: Hi can any one help me

i need to make a sql db om my sme 7.0 server

please help
Title: MySQL server on SME 7.0
Post by: dsemuk on September 04, 2006, 08:21:10 PM: What do you need to know about MySQL on SMEserver?

If you need help with building a MySQL database have a look here:

http://mysql.com/support/

Dave
Title: Re: MySQL server on SME 7.0
Post by: cactus on September 04, 2006, 08:40:14 PM: Quote from: "a55830"
Hi can any one help me

i need to make a sql db om my sme 7.0 server

please help

[Log in to your console as root and issue the following line to log in to mysql as root user:
Code: [Select]
mysql -u root
To create a database:
Code: [Select]
create database db_name
Create a user with all privileges for the database just created :
Code: [Select]
grant all privileges on db_name.* to username@localhost identified by password; flush privileges;
You now have created a user which can access the database from the localhost (so server only access). For more details see the MySQL manual on creating databases (http://dev.mysql.com/doc/refman/4.1/en/create-database.html) and assigning user(privilege)s (http://dev.mysql.com/doc/refman/4.1/en/grant.html).
Title: MySQL server on SME 7.0
Post by: a55830 on September 04, 2006, 09:15:12 PM: thx for the help

iv now created my db
and the user

i get query OK , 0 rowa affected (0.03 sec)

how do i connect to it ???

i like to use MySQL admin
Title: MySQL server on SME 7.0
Post by: cactus on September 04, 2006, 09:37:38 PM: Quote from: "a55830"
thx for the help

iv now created my db
and the user

i get query OK , 0 rowa affected (0.03 sec)

how do i connect to it ???

i like to use MySQL admin
mysqladmin can be accessed from the command line just like the mysql command. For help type
Code: [Select]
mysqladmin --help
Title: MySQL server on SME 7.0
Post by: a55830 on September 04, 2006, 09:48:30 PM: well iv done that but im not in to text (command line) is there not a way i can connect from my windows machine and doo it not "command line" way but window way :-D :-D
Title: MySQL server on SME 7.0
Post by: cactus on September 04, 2006, 10:01:24 PM: Quote from: "a55830"
well iv done that but im not in to text (command line) is there not a way i can connect from my windows machine and doo it not "command line" way but window way :-D :-D
Install the phpmyadmin contrib found in the contrib section (http://no.longer.valid/phpwiki/index.php?ContribsPage), this will make mysql available in a web interface or search the FAQ how to connect to mysql from your local network and use your favorite tool (e.g. Navicat, MySQL Adminstrator).
Title: MySQL server on SME 7.0
Post by: a55830 on September 04, 2006, 10:27:37 PM: ok i got the file

well my linux is not the best so can you pin out what to doo :-?

im a bit lost
Title: MySQL server on SME 7.0
Post by: TrevorB on September 05, 2006, 04:40:56 AM: Quote from: "a55830"
ok i got the file

well my linux is not the best so can you pin out what to doo :-?

im a bit lost

If you've already downloaded the .rpm just install via yum
yum localinstall <rpm file>
Title: MySQL server on SME 7.0
Post by: Janm on September 05, 2006, 05:10:06 AM: Make a directory for different extra rpms on server and cd to it
and then do
-------------------------------------------------------------

wget http://mirror.contribs.org/smeserver/contribs/dmay/smeserver/7.x/smeserver-phpmyadmin-2.6.4-pl4.dmay.noarch.rpm
yum localinstall smeserver-phpmyadmin-2.6.4-pl4.dmay.noarch.rpm
-------------------------------------------------------------
or the rpm file name
then do
-------------------------------------------------------------
Connect to your server with
-----------------------------
https://xxx.xxx.xxx.xxx/phpmyadmin
use your admin conto and password
Then create a new user fks admin
---------------------------------
admin
localhost
adminspassword
adminspassword

and create

Finish close myphpadmin
----------------------------------------
Hope that could get you going
Have been there myself and many peaple have helped me Here
on Contribs.org Faq so i say thanks to all you know who you are
Speciel to
Mr John Bennet the third
Edited 06-09-2006 time europa:08:07 Jan Advise From CACTUS Thanks
Jan in DK
Title: MySQL server on SME 7.0
Post by: william_syd on September 05, 2006, 03:51:15 PM: If you want to stay working in windows...

ssh(Putty) into SME and do...

Code: [Select]
/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no /sbin/e-smith/expand-template /etc/my.cnf /etc/rc.d/init.d/mysqld restart

If it wont restart then reboot...
Code: [Select]
/sbin/e-smith/signal-event post-upgrade /sbin/e-smith/signal-event reboot

Then...
Code: [Select]
mysql GRANT ALL PRIVILEGES ON *.* TO 'SQLyog'@'ip_of_windows_box' IDENTIFIED BY 'newpassword' WITH GRANT OPTION ; \q
Then get a copy of SQLyog Free Edition from http://www.webyog.com/en/index.php and run it on your windows machine.
Title: MySQL server on SME 7.0
Post by: a55830 on September 05, 2006, 07:31:31 PM: THX

i cant thank you enough for the great help

ill hope i can bee that good one day so i can help some one like me
Title: MySQL server on SME 7.0
Post by: cactus on September 05, 2006, 07:58:12 PM: Quote from: "Janm"
wget http://mirror.contribs.org/smeserver/contribs/dmay/smeserver/7.x/smeserver-phpmyadmin-2.6.4-pl4.dmay.noarch.rpm
rpm -Uvh *.rpm
IPlease use yum localinstall instead of rpm -Uvh. Yum is the preferred method of installing rpm's for SME Server as this will also try and download all neccesarry dependencies.