A client asked me to create a Database for his school, to house all the student records etc. This isn't usually what I do as I am doing my Major in Game programing. Now I went with Access or Base but they both will need to be installed on his machine. I tried going with SQLite But it doesn't have a front-end. So in short, I want to devalop A SQL baseed DB with a simple GUI Frontend. Where Should I head now, Or Any books which feature such cases. The database will be initially be offline.
Hello all
I am trying to create a Hyper-V 2012 Virtual machine running Cent0S 6.5 for a client. Currently I have the VM set up with two SCSI disks one of size 25GB and one of size 60 GB.. The 25 GB disk will be the OS disk and the 60 GB disk will be the data disk which holds the data from the database. I want to create an LVM on the 60 GB disk and increase it over time as the database gets bigger. As soon as the disk gets to about 1 TB, I will create a third disk, and extend the Volume Group to include that third disk as well. The third disk will eventually grow past 1TB as well (but not 2TB)
Overall my question is, would this type of set up be possibly using a MBR Bios set up? or would I HAVE To use GPT?
all help is greatly appreciated!
Hello,
I generated and uploaded a public key through SSH Client software to our dedicated server. It works fine from the computer I have generated.
My laptop windows become corrupt and I downloaded this key from my email that is attached previously.
Now I am trying to import in SSH Client but its throwing error that unable to read this key file
Can I generate public key from our dedicated server and upload as attachment in my email so that whenever I want I can use and access our server from any machine?
Please advise
Thanks in anticipation
hye all... 1st of all merry Christmas...
i'm degree student.. and now i have to do final year project..
my project is proxy server.. my problem is i want to connect config file from squid to database server...
i must install squid on fedora and database on difference PC... anyone can help me...
I set up public key authentication between my MacBook and and VPS for added security and convenience when I SFTP things to my VPS.
Now I have some new clients who want me to manage their websites, and I want a similar set up for each client.
Do I need a public/private key pair for each client?
How can I be sure that whatever I do in my SFTP client doesn't put the other accounts - particularly my own VPS - at risk?
Thanks,
Rob
I am in the process of setting up my first VPS to host a website that I have been working on. By profession, I am a programmer, so I know nothing of Linux or web hosting!!
Thanks to lots of help on here this weekend, I finally learned how to access my VPS using SSH. (That only took a day or two to learn!) And my first command-line task was learning how to copy a file to another folder while maintaining the original modified date. (That only took another half-day!)
Whew!
So the next thing that I need to do is set up MySQL on my VPS...
My VPS runs on CentOS 6, and it also comes with cPanel, but since astrogeek and Miati were persistent in explaining why it is better to do things via the command-line versus using a GUI, I figured I would check things out...
My cPanel comes with some "wizard" that supposedly sets up a MySQL database for you, but whenever I see "wizard" I tend to run!
Advanced Support for my web host said that I should definitely use cPanel to create my database and create the users, because if I did it using phpMyAdmin it would supposedly mess things up as cPanel wouldn't recognize things?
(BTW, I requested MySQL Root access this morning, but I do not have Root access to my VPS - by choice for now!)
Questions:
1.) Should I listen to my web host and use the cPanel wizard to create a new MySQL database?
2.) If I decide to bypass cPanel, how exactly would I use my MacBook to talk to my VPS and do MySQL stuff over command-line?
FWIW, I developed my entire database using phpMyAdmin in MAMP on my MacBook. When I created my original database in development, I used phpMyAdmin's GUI. And then for everything else (e.g. create table, indexes, queries, etc.), I hand-wrote the SQL in TextEdit and then ran it in phpMyAdmin.
But I have no clue how to do any of this on my VPS!!
3.) How would I use the command-line to create a new database and set up groups and users for MySQL?
4.) If I did things by command-line, is it true that I would break cPanel?
I have been working on my website for the last 3 years, and it is ready to "go live", but I am discovering that setting up my VPS properly - and with lots of security - and getting things like PHP and MySQL set up is a very daunting task!!!
Sincerely,
Rob
Hi all,
I'm aspiring new Linux Administrator and I have been given tasks of looking at various Linux servers and clients. As a newbie, I often forget/confuse about the series of steps I should take to accomplish certain tasks against various types of Linux distro. So I have some large no of notes in text file format, which i often refer to.
Earlier I used Microsoft OneNote, which can be used to view/update/create notes from my home PC, my Android phone or through various web browsers at client's site. But now, I am not able to access notes simply because, (1) MS SkyDrive is too slow, (2) Many of Linux machines have no GUI, (3) I'm not allowed to carry my Android phone inside server rooms, etc.
Long story short, I should be able to access my text notes in terminal from any machine which has internet connection. And also if I may extend, also in my android phone.
What I have with me is one .com domain with hosting space for next 1 year.
Any Idea on how I should proceed will be really appreciated.
Many thanks.
mysqladmin -u root -p version
this is the command used to get version of MySql database.
similarly how can i get the details of any database installed??
Hello Guys,
I am an newbie, just started with linux, I have installed centos 6.6 and learning it. But I got stuck in some user controls,
Now In my company I wanted to have an Linux Server and need to do the user authentication and wanted to create domain, But also wanted that my Client OS would be MAC and Windows..
Can anybody Help ??
Please reply here or in my email :- Yerunkar11@gmail.com
Once again thanks Again for reading, really appreciated
I have installed phpmyadmin , when access http://192.1010.118.0/phpmyadmin ,it pops the error
Code:
Forbidden
You don't have permission to access /phpmyadmin on this server.
I check the phpmyadmin.conf , I have released "allow all" to all directory .
I also check the /var/log/httpd/error_log, it have the following error , I tried change all files permission to 777 but still not work , would advise what is wrong in my server ? thanks
Code:
[authz_co error] [pid 2525] [client 192.1010.118.0:51878] AH01630: client denied by server configuration: /usr/share/phpMyAdmin
Hello all,
I'm having real trouble trying to get SVN 1.8.9 installed on a linux box which is now my responsibility to look after, I think it is centos or scientific linux.
EDIT: it is Scientific Linux release 6.4 (Carbon)
What I've done so far:
SVN 1.6 was installed and working fine.
I installed smartsvn so that I had a 'nice' GUI to look at the repos on the machine.
Smartsvn then upgraded my repos.
The svn client on the command line does not work with the upgraded repos.
I tried yum install svn but the latest svn is already installed (1.6).
I then installed 1.7 from source and still that version was too old.
I then installed 1.8.9 from source - yey this worked locally fine.
There are cron jobs that run and use the svn client to push to an svn server
The SVN I installed from source does not commit properly and gives this error:
svn: E170000: Unrecognized URL scheme for 'http://.....'
I googled around and found I need to install svn with configure --with-serf option.
This fails as the SVN install needs serf 1.2.1 or newer.
So I install serf 1.3.something from an rpm.
That installs fine and I retry the configure step but it fails giving the same error.
rpm -ql serf returns: /usr/lib/libserf-1.so
/usr/lib/libserf-1.so.1
/usr/lib/libserf-1.so.1.3.0
So I think 1.3 is installed...?
Does anyone know how to make the configure step of svn know where serf is? --with-serf=/usr/lib/ did not work at all for me.
Thanks for any help and I'm happy to post more information.
Cheers