Koozali.org: home of the SME Server

MySQL server on SME 7.0

Offline a55830

  • *
  • 9
  • +0/-0
    • http://blueeye.dk
MySQL server on SME 7.0
« 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

Offline dsemuk

  • *****
  • 269
  • +0/-0
MySQL server on SME 7.0
« Reply #1 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
--
Esmith/Mitel/SME server  :-D...

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: MySQL server on SME 7.0
« Reply #2 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 and assigning user(privilege)s.
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline a55830

  • *
  • 9
  • +0/-0
    • http://blueeye.dk
MySQL server on SME 7.0
« Reply #3 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

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
MySQL server on SME 7.0
« Reply #4 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
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline a55830

  • *
  • 9
  • +0/-0
    • http://blueeye.dk
MySQL server on SME 7.0
« Reply #5 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

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
MySQL server on SME 7.0
« Reply #6 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, 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).
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline a55830

  • *
  • 9
  • +0/-0
    • http://blueeye.dk
MySQL server on SME 7.0
« Reply #7 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

Offline TrevorB

  • *
  • 259
  • +0/-0
    • http://www.batley.id.au
MySQL server on SME 7.0
« Reply #8 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>

Janm

MySQL server on SME 7.0
« Reply #9 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

Offline william_syd

  • *****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
MySQL server on SME 7.0
« Reply #10 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.
Regards,
William

IF I give advise.. It's only if it was me....

Offline a55830

  • *
  • 9
  • +0/-0
    • http://blueeye.dk
MySQL server on SME 7.0
« Reply #11 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

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
MySQL server on SME 7.0
« Reply #12 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.
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)