LinuxQuestions.org
Help answer threads with 0 replies.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Debian
User Name
Password
Debian This forum is for the discussion of Debian Linux.

Notices


Reply
  Search this Thread
Old 05-16-2010, 12:17 AM   #1
jinu rajan
LQ Newbie
 
Registered: May 2010
Posts: 3

Rep: Reputation: 0
Post how to handle sql in debian


hai,being a btech student we have an asignment on call centre management.i have the source code and know how to do it in windows,but i prefer to do it in linux tats in debian5.can you tell me how to handle sql database in debian5?also after debian installation i cant login as a root but can acess root terminal from home.how can i solve this?is it because of wrong partitioning during installation?
 
Old 05-16-2010, 12:31 AM   #2
EricTRA
LQ Guru
 
Registered: May 2009
Location: Gibraltar, Gibraltar
Distribution: Fedora 20 with Awesome WM
Posts: 6,805
Blog Entries: 1

Rep: Reputation: 1297Reputation: 1297Reputation: 1297Reputation: 1297Reputation: 1297Reputation: 1297Reputation: 1297Reputation: 1297Reputation: 1297
Hello and welcome to LinuxQuestions,

You'll have to provide some more information about what errors you are getting when accessing your Debian machine. At what level are you unable to login as root? Graphical interface or console? Logging in in my opinion doesn't have anything to do with the partitioning you configured on setup.

About the database question, have a look at PostgreSQL and MySQL. I believe MySQL is the most distributed and known one of the two. Also don't post homework since we're not here to do it for you. We'll be happy to assist you in finding solutions for your problems by pointing you in the right direction.

Kind regards,

Eric
 
Old 05-16-2010, 04:06 AM   #3
evo2
LQ Guru
 
Registered: Jan 2009
Location: Japan
Distribution: Mostly Debian and CentOS
Posts: 6,724

Rep: Reputation: 1705Reputation: 1705Reputation: 1705Reputation: 1705Reputation: 1705Reputation: 1705Reputation: 1705Reputation: 1705Reputation: 1705Reputation: 1705Reputation: 1705
Quote:
Originally Posted by jinu rajan View Post
hai,being a btech student we have an asignment on call centre management.i have the source code and know how to do it in windows,but i prefer to do it in linux tats in debian5.can you tell me how to handle sql database in debian5?
Two of the more popular sql databases commonly packaged with linux distributions are mysql and posgresql. Have a google and a read about them. Then try installing using your package manager, and read the documentation that comes with the package.

Quote:
also after debian installation i cant login as a root but can acess root terminal from home.how can i solve this?is it because of wrong partitioning during installation?
By default Debian sets up the login manager to not permit root login in X. This is a "feature" designed to enhance security.

Evo2.
 
Old 05-17-2010, 07:42 AM   #4
scheidel21
Senior Member
 
Registered: Feb 2003
Location: CT
Distribution: Debian 6+, CentOS 5+
Posts: 1,323

Rep: Reputation: 100Reputation: 100
Not wise, but you can still get a Root GUI session without disablign the GUI login restriction just log in as root on the command line the launch startx or startkde or whatever. And as was mentioned before You need a database server to process SQL, in Wndows it is frequently either MS SQL server or MySQL. With Linux usually MySQL or PostgreSQL. And SQL is SQL the syntax is really the biggest difference and the enhanced features are different too. Like T-SQL is only applicable to SQL Server from Microsoft. But you can pick up a nice handy pocket reference from O'Reilly Press that has SQL Syntax for most SQL commnade for SQL Server, MySQL, Oracle, and I think Postres
 
Old 05-20-2010, 10:02 PM   #5
jinu rajan
LQ Newbie
 
Registered: May 2010
Posts: 3

Original Poster
Rep: Reputation: 0
while login as root,it is showing that the system administrator does not allow......like that.i want to change the grub order.for that i want to login as root.can you tell me in detail how to enter into root through command line?or how can i login in into root via graphical interface?
 
Old 05-20-2010, 10:06 PM   #6
jinu rajan
LQ Newbie
 
Registered: May 2010
Posts: 3

Original Poster
Rep: Reputation: 0
from where can i take SQL in debian 5?how can i attach database in SQL debian?i am not at all familiar with debian just stared to use it
 
Old 05-21-2010, 07:36 AM   #7
evo2
LQ Guru
 
Registered: Jan 2009
Location: Japan
Distribution: Mostly Debian and CentOS
Posts: 6,724

Rep: Reputation: 1705Reputation: 1705Reputation: 1705Reputation: 1705Reputation: 1705Reputation: 1705Reputation: 1705Reputation: 1705Reputation: 1705Reputation: 1705Reputation: 1705
Hi,

Quote:
Originally Posted by jinu rajan View Post
i want to change the grub order.for that i want to login as root.can you tell me in detail how to enter into root through command line?
At the command line enter the following command.
Code:
su -l
Then you will be prompted for you root password. After that you will be root in that terminal.

I get the felling that you are not just new to Debian but new to *nix style operating systems in general. I'd suggest you do a little background reading. Please have a look at the newbie forum on this site for ideas for reading material.

Cheers,

Evo2.
 
Old 05-21-2010, 07:41 AM   #8
evo2
LQ Guru
 
Registered: Jan 2009
Location: Japan
Distribution: Mostly Debian and CentOS
Posts: 6,724

Rep: Reputation: 1705Reputation: 1705Reputation: 1705Reputation: 1705Reputation: 1705Reputation: 1705Reputation: 1705Reputation: 1705Reputation: 1705Reputation: 1705Reputation: 1705
Quote:
Originally Posted by jinu rajan View Post
from where can i take SQL in debian 5?how can i attach database in SQL debian?i am not at all familiar with debian just stared to use it
I don't know what you mean by "attach database". Install database? Connect to some other database server?

Anyway in general if you want use software you need to install the packages. For example mysql-server and mysql-client. Then read the documentation. Come back and ask if you have specific questions.

If what I've said makes no sense, then please try to clarify what you want to do.

Evo2.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL update statement to SQL SERVER 2005 scheidel21 Programming 2 11-05-2009 06:30 PM
SQL noob question: can SQL effectively handle a 2D matrix? JoeyAdams Programming 2 03-17-2008 01:10 AM
LXer: Sql - stored procedures, views, and dynamic sql generation LXer Syndicated Linux News 0 08-17-2006 06:33 AM
SQL: old sql dump not loading into new db BrianK Linux - Software 1 07-25-2006 11:55 PM
Trying to mount W2k3 shareusing Samba 3.0.14a-Debian gives Stale NFS file handle lbclinux Debian 1 08-21-2005 07:07 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Debian

All times are GMT -5. The time now is 05:21 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration