Phat Site Blog

Hi, ive been playing around making websites with php, and i want to create a mysql database. Ive got a book that tells me how to do it but it doesnt actually tell me how to connect to my server. Iv registered webspace that allows mysql databases, but how to I connect to it through a command prompt on my windows machine? Is there any software I have to install? Thanks for any replys, Ben.

How do i connect to a mysql server from my windows machine?

The Perfect Setup – CentOS 4.3 (64-bit)

Version 1.2
Author: Falko Timme <ft [at] falkotimme [dot] com>
last edited 05/20/2007

This is a detailed description how to set up a CentOS 4.3 based server that offers all services needed by ISPs and hosters (web server (SSL-capable), mail server (with SMTP-AUTH and TLS!), DNS server, FTP server, MySQL server, POP3/IMAP, Quota, Firewall, etc.). This tutorial is written for the 64-bit version of CentOS 4.3, but should apply to the 32-bit version with very little modifications as well.

I will use the following software:

• Web Server: Apache 2.0.x
• Database Server: MySQL 4.1
• Mail Server: Postfix (easier to configure than sendmail; has a shorter history of security holes than sendmail)
• DNS Server: BIND9 (chrooted!)
• FTP Server: proftpd
• POP3/IMAP server: dovecot
• Webalizer for web site statistics

In the end you should have a system that works reliably, and if you like you can install the free webhosting control panel ISPConfig (i.e., ISPConfig runs on it out of the box).

I want to say first that this is not the only way of setting up such a system. there are many ways of achieving this goal but this is the way I take. I do not issue any guarantee that this will work for you!

Requirements

To install such a system you will need the following:

• Download the 4 CentOS 4.3 CD iso images from a mirror near you (the list of mirrors can be found here: http://www.centos.org/modules/tinycontent/index.php?id=13).
• an internet connection…

1 Install the Base System

Boot from your CentOS 4.3 CD (CD 1).

it can take a long time to test the installation media so we skip this test here:

the welcome screen of the CentOS installer appears. Click on Next:

Choose your language next:

Select your keyboard layout:

we want to install a server so we choose Server here:

Next we do the partitioning. Select Automatically partition. This will give you a smalll /boot partition and a large / partition which is fine for our purposes:

I’m installing CentOS 4.3 on a fresh system, so I answer Yes to the question Would you like to initialize this drive, erasing ALL DATA?

Select Remove all partitions on this system.

We want to remove all Linux partitions, so we answer Yes to the following question:

the installer presents you an overview of our new partitions. Click on Next:

now the boot loader GRUB will be installed. you can leave the default settings unchanged and click on Next:

Building A LowCost LAMP Server For Your Webhosting Business With CentOS 4.3

The Cube Host – Quality Web Solutions in a Cube

Our Shared Hosting Plans are ideal for whatever web project you may have because they come with an great amount of features to give you the flexibility with your hosting package.

We guarantee that you will be satisfied with our plans. Our servers are monitored 24/7 to ensure that your site is up when you and your clients need it. Our uptime levels are backed by our 99.9% Uptime Guarantee. if we don’t deliver the uptime, we will refund you a percentage for the downtime you encountered.

All our hosting accounts and domains are set up instantly so if you sign up with us right now, you won’t be wasting anytime. You can get straight to work.

We back up our service with a 14 Day Money back Guarantee. if your not satisfied with our service, you have 14 days to request a refund. You have nothing to lose! Sign up today.

Special Offer
Use the promotional code minus25 to get 25% off your first invoice as well as all recurring invoices.

Bronze Shared
* Cost: $3.95 before discount
* WebSpace: 5GB
* Bandwidth: 75GB
* 24/7 Server Monitoring
* 99.9% Uptime Guarantee
* Instant Activation
* 14 Day Money back Guarantee
* Free Website Builder (RVSiteBuilder Pro)
* cPanel/RVSkin/Fantastico
* PHP/Perl/CGI-BIN/Zend/Curl/Ruby-on-Rails
* More Information | Order Now!

Silver Shared
* Cost: $5.95 before discount
* WebSpace: 15GB
* Bandwidth: 100GB
* Free Domain (Annual Payment)
* 24/7 Server Monitoring
* 99.9% Uptime Guarantee
* Instant Activation
* 14 Day Money back Guarantee
* Free Website Builder (RVSiteBuilder Pro)
* cPanel/RVSkin/Fantastico
* PHP/Perl/CGI-BIN/Zend/Curl/Ruby-on-Rails
* More Information | Order Now!

Gold Shared
* Cost: $7.95 before discount
* WebSpace: 25GB
* Bandwidth: 125GB
* Free Domain (Annual Payment)
* 24/7 Server Monitoring
* 99.9% Uptime Guarantee
* Instant Activation
* 14 Day Money back Guarantee
* Free Website Builder (RVSiteBuilder Pro)
* cPanel/RVSkin/Fantastico
* PHP/Perl/CGI-BIN/Zend/Curl/Ruby-on-Rails
* More Information | Order Now!

Bronze Reseller

* Cost: $5.95 before discount
* WebSpace: 5gb
* Bandwidth: 50gb
* 24/7 Server Monitoring
* 99.9% Uptime Guarantee
* Free Domain Reseller Account
* Dedicated name Servers – On Request
* Overselling Allowed
* Instant Activation.
* 14 Day Money back Guarantee
* Free Website Builder (RVSiteBuilder Pro)
* cPanel/WHM/RVSkin/Fantastico
* PHP/Perl/CGI-BIN/Zend/Curl/Ruby-on-Rails
* More Information | Order Now!

Silver Reseller

* Cost: $10.95 before discount
* WebSpace: 10gb
* Bandwidth: 75gb
* 24/7 Server Monitoring
* 99.9% Uptime Guarantee
* Free Domain Reseller Account
* Dedicated name Servers – On Request
* Overselling Allowed
* Instant Activation
* 14 Day Money back Guarantee
* Free Website Builder (RVSiteBuilder Pro)
* cPanel/WHM/RVSkin/Fantastico
* PHP/Perl/CGI-BIN/Zend/Curl/Ruby-on-Rails
* More Information | Order Now!

Gold Reseller

* Cost: $14.95 before discount
* WebSpace: 20gb
* Bandwidth: 150gb
* 24/7 Server Monitoring
* 99.9% Uptime Guarantee
* Free Domain Reseller Account
* Dedicated name Servers – On Request
* Overselling Allowed
* Instant Activation
* 14 Day Money back Guarantee
* Free Website Builder (RVSiteBuilder Pro)
* cPanel/WHM/RVSkin/Fantastico
* PHP/Perl/CGI-BIN/Zend/Curl/Ruby-on-Rails
* More Information | Order Now!

Have Questions?
If you have any questions, feel free to send us an email at presales (at) thecubehost.com

The Cube Host – Shared & Reseller Hosting – 25% Off For Life …

According to the U.S. Department of Labor, despite adding 162,000 jobs last month, the nationwide unemployment rate held steady at 9.7%. Data introduced today by Elance shows online work continues to grow at a steady pace as its talent pool earned more than $20 million in the first quarter of 2010, surpassing a total of $260 million of work completed to date on Elance. This represents a nearly 40% increase year-over-year and demonstrates that businesses are increasingly turning to online talent, an important and thriving employment segment, to drive their economic recovery.

“Businesses are increasingly incorporating more flexible work arrangements, self-employed workers and a shift to using online workplaces into their strategy,” said Ellen Pack, Vice President of Marketing at Elance. “Companies are turning to online talent for mobile development, open source, social media and cloud computing, making these the fastest growing skills in demand on Elance. In fact, businesses are finding it easier and more cost-effective to hire certain types of talent online, rather than onsite,” said Pack.

Notable hiring trends this past quarter include:

· Mobile on the Move – overall, the biggest rise in demand came in the mobile development skill, which soared 21 places in the IT category. (Quarter over quarter, the Mobile category shows a 98% increase in the number of job posts by employers.)

· iPad makes its debut on the IT top 50 Skills list.

· as new devices emerge across all major networks, Google shows no signs of slowing down as Android moves up 10 positions.

· The expected release of the next generation iPhone later this year led iPhone development skills to move up three spots into the top 10 IT Skills, and Objective-C skills (iPhone and Mac OSX programming language) moved up three spots as well.

· Social Media is in Season – Businesses are increasingly seeing Social Media as an important marketing channel that requires development and ongoing monitoring. In the first quarter, Social Media jobs have spanned across the Marketing and IT categories. In the IT category, businesses are looking for developers to create applications to tap into social networks with Facebook Development up three spots and Social Networking Apps moving up one spot. In the Marketing category, Social Media Marketing is up three spots jumping into the top five skills in the category.

· Open Source on the Rise – Businesses and entrepreneurs continue to adopt open source platforms for a variety of reasons, including complete customization and community development. Currently, open source technologies represent 20% of the IT top 50 Skills list. Open source content management systems like WordPress, Joomla!, and Drupal, are currently driving the movement with extremely high demand, while database, mobile, eCommerce, and web server technology platforms closely follow.

· Cloud Computing Momentum – with Amazon, Salesforce, Google, Microsoft, and other major players entering the space, application development in the cloud is gaining traction. Both Web Services and Amazon Web Services moved up one notch each, and popular cloud computing languages like PHP, ASP.NET, Ruby on Rails, and Python, are strongly represented in the IT top 50 Skills.

Beyond these top four fastest-growing skill categories on Elance, the report reveals that the United States continues to hold the #1 spot for delivery of services in the Creative category and the #2 spots for Marketing and Operations. India ranks #1 in the IT, Marketing and Operations categories. top U.S. cities in Q1 for provider earnings include 1) new York, 2) Los Angeles, 3) Dallas, 4) Amarillo, and 5) Chicago (note: Amarillo jumped into the top five from the 20th spot last quarter). The top ten states for online talent earnings in Q1 include California, Texas, new York, Florida, Illinois, Pennsylvania, Washington, Ohio, Oregon, and Georgia. The five fastest movers rising on the charts are Idaho (up 9), North Carolina (up 6), new Hampshire and Louisiana (up 4), and Oregon (up 3).

Elance is experiencing record year-over-year growth as more businesses embrace hiring online talent. Currently, more than 100,000 businesses are actively tapping into more than 106,000 tested experts on Elance. to access the full Elance Online Talent Report, please click here.

About Elance

Elance, the world’s leading online talent marketplace, helps companies hire and manage professionals online to get work done and grow their businesses.

Elance instantly matches employers with a ready and qualified workforce of more than 106,000 rated and tested professionals with technical, marketing and business skills, and provides the tools to manage online and pay for results. with more than $260 million in earnings to date, contractors and service providers around the world use Elance to meet employers and get paid for delivering great results.

The company is privately held and headquartered in Mountain View, California. for more information, visit Elance at http://www.elance.com.

Elance Report Reveals More Businesses Turning to Online Talent

So I’ve been a professor at this ‘little school’ for a while now. I love my job. My classes contain students from all age groups. I have a few 17 year old high schoolers that are here because they are bored during the summer. I have a few seasoned folks that have IT experience. I also have a few people that are clearly here just for the three credit hours.

The classroom is set up in a ‘lab’ environment. each student has a PC in front of them that netboots linux from a central box located near my desk at the front of the classroom. This setup works great because the students come into the classroom every day, power on their PC, and they get the exact OS load and lesson they need for our session. Not to gloat, but I designed it this way and I’m the envy of a few other professors *cough* windows instructors *cough*.

Computer teacher pwns l33t h4×0r kid in his class. Classic.

Colorado Springs (PRWEB) February 5, 2007 – New Frontier Bank, based in Greeley, Colo., has become the first bank in the nation to acquire and install self-service shredding kiosks for customer and public use.

New Frontier Bank has installed the Self-Service Shredder, the first self-service shredding kiosk designed specifically for business and consumer use, at its locations in Greeley, Longmont, and Windsor, Colo. the kiosks, developed by Colorado Springs-based RealTime Shredding, inc., cross-cut shred paper, cardboard, credit cards, paper clips, staples, CDs, DVDs, and floppy disks. the industrial-strength shredder, featuring multiple control points for maximum safety, can shred up to 200 sheets of paper a minute.

New VPS Hosting Plans using CentOS 5, including Latest Versions of …

In what is becoming the rule rather than the exception, Digg is the latest social media player to “come out of the closet” and not only acknowledge that it is built on open source components, but they have contributed to and host several open source projects. Like Facebook and Twitter, Digg loves open source.

Digg has put up its own open source page that lists which open source components Digg uses, libraries it hosts and so on. Here is what they say:

We also give back by mirroring a couple of projects; PEAR and Debian. further, we maintain Debian packages of some of the projects below, indicated by Debian ,

So if you run Debian, be sure to check out our instructions on building your own Debian packages. the projects distributed through the PEAR repository are indicated by PEAR.

Interestingly Digg is another user of Cassandra, the Facebook developed distributed data storage system. Digg has also gone a step further and made many of the Digg packages ready to run on Debian Linux. They are also storing a lot of their open source stuff on their own Github page.

Digg’s love of open source is one more illustration that open source is really powering the social media revolution. Recent analysis is also indicating that open source will be a major factor in the adoption of cloud computing as well.

The move to the cloud and (I hate the term, but what can I do), web 2.0 technologies has really been ushered in by a golden age of open source dominance. What is interesting is that all of these companies are not afraid of losing their competitive edge by sharing their open source components.

Digg Takes Pride in Open Source Usage, Contributions

One of my clients uses CentOS for the production platform of their (web) application (written in PHP). They’ve asked me to take over the development and maintenance of their web application, so, naturally, I set up a new server with CentOS 5.2, rather than the Debian installation I would normally use.

I like Debian for a lot of reasons: it is generally a stable system that is well-documented, secure and easy to handle. the “easy to handle” part is, of course, because I happen to know my way around a Debian system. When I started out, seven years ago, professionally working on Linux systems, I started out on the then-current RedHat distro.

A lot has changes since then.

Sometimes I feel like a real geezer when I say that, but having memory go back a decade or more in computer science is like having a living memory go back to the middle ages in history: “civilization” started a few thousand years ago in “real” life, while it started only a few decades ago where computers are concerned. the age when computers arrived in the household is recent enough for me to remember it.

Anyway, back to the topic at hand. There are actually very few differences between CentOS and Debian: in many respects, they are very similar. I would argue that the CentOS installation is a bit more user-friendly in the way it set up its interface by default, but Debian has a better installer (apt) that CentOS does (it uses yum), though yum uses the RPM format while apt uses its own format – and RPM is the Linux standard, at least in the Linux Standard Base.

Debian has a lot more packages available, though – but for running a LAMP, that doesn’t change much.

So basically, for running a LAMP, I found them pretty much equivalent – though I will continue to prefer Debian because I know my way around better. both do the job of running a LAMP just fine, both have a “when it’s ready” approach to releasing and both are well-documented.

Running a LAMP: Debian vs. CentOS @ Making Life Easier

Setup Easy Hosting Control Panel (ehcp) for Debian/Ubuntu

Posted by dgs on February 2nd, 2008

If you’re new here, you may want to subscribe to my RSS feed. thanks for visiting!

ehcp is a new Hosting Control Panel in Linux world. although it is in beta stage, its basic functions are well functioning. it operates strongly with debian/ubuntu”s apt-get package manager..

it differs from other control panels, or even other opensource panels that, ehcp is the first and only: opensource,full php, object oriented, gpl, free hosting control panel on the earth !

You may use ehcp to easily setup a hosting environment, for yourself or for selling hosting..You may also use it for only ftp hosting..

A clean ubuntu or any debian based linux install. nothing else. any apt-get enabled linux is enaugh.

to install copy and paste following on your linux console:

wget http://www.ehcp.net/ehcp_latest.tgz

tar -zxvf ehcp_latest.tgz

./install.sh
#

the installer will ask some questions about your settings, then will automatically install any needed server programs such as apache, mysql and so on..

After installer finishes, navigate to localhost (if you installed on local) or to ip by typing at address bar of your browser.

default login: admin
default pass: 1234

you may find additional information check here, test ehcp on a real server at http://83.133.127.19.

• List of Ubuntu Based Linux Distributions and Live Cd’s
• Running ASP.NET Applications in Debian and Ubuntu using XSP and Mono
• Avast Antivirus for Ubuntu Desktop
• Find, edit and share your Photo Albums with Picasa in Ubuntu
• Cross-platform calendar using Sunbird in Ubuntu
• F-Prot Antivirus with Web Interface
• VHCS ISP Control Panel Installation with Screenshots

You can leave a response, or trackback from your own site.

Setup Easy Hosting Control Panel (ehcp) for Debian/Ubuntu …

2010-04-19 09:45:42 – World-Wide Beginners & Proficient Online Businessmen can avail Comprehensive IT services and Hire Developers for different Web Development services and save up to 60% of Development cost..

Surfing web for appropriate IT services is common practice after the economic outsourcing trends adopted by the business companies. A large number of offline businesses from different industries are regularly coming on the web to globalize their business for the last many years. Web is the source of global exposure for business companies as well as source of IT services

for economic web development. the search for appropriate and customized business website development has increased rapidly on the web. HiddenBrains is the professional web development company announces Comprehensive IT services & PHP Web Development with Hire Dedicated Developer Program. Company is well-organized with professionals like expert web developers, designers, and SEO professionals.

HiddenBrains offer a series of IT services like Ecommerce Solutions, Open Source Customization, Software Development, Website Development, Application Migration, Rich Application Development, Website Designing and eMarketing / Internet Marketing. Company provides a single platform for short & medium sized companies as well as large companies and offers economic & customized web development services. Web developers & designers are proficient & talented to utilize various technologies, programming languages and web development tools.

“We are committed to provide high quality & customized web development services to novice and established businessmen,” states Ram Chauchariya, CEO of HiddenBrains.” Company also provides “Hire dedicated web developers” proficient in different technologies and programming languages to meet specific requirements of clients. Clients can save up to 60% of development cost by hiring specific programmer. For providing robust web development services, company professionals use a wide range of core & latest IT technologies, frameworks, programming languages, databases and other web development tools.

To learn more about HiddenBrains and its services, visit www.hiddenbrains.com/ for details.

About HiddenBrains:
HiddenBrains is a leading service provider of web development. Established in 2003 and headquartered in Ahmedabad City, the company specializes in complete web development solutions that meet business and web consumer needs. the company’s web development services have been used by millions of people in various countries.

HiddenBrains Infotech – an Offshore Software & Web Development, PHP/ASP.Net/AJAX/RoR Programming, Ecommerce Solutions and Rich Web 2.0 Application Development Company from India.
HiddenBrains InfoTech is an ISO 9001:2008, Offshore Software development, Outsourcing iPhone/Mobile Application Development and PHP, ASP.Net, Web Application Development Company in India, offering IT outsourcing software development services. Expertise in PHP (hypertext preprocessor) and Microsoft .Net Framework and have expertise in XML, AJAX, Open Source, CakePHP, LAMP(Linux,Apache,Mysql,PHP), Ruby on Rails (RoR), ColdFusion.

Leaders in : Mobile/Android/Blackberry/iPad/iPhone application development, web 2.0 design, social network and community web portal development, e-commerce, hire php developer, hire asp.net developers.
Custom Firefox Toolbar Development, Firefox Extensions Development, IE Plugins, IE Toolbar Development, Hire Firefox/XUL Developers. Custom Wordpress CMS theme design customization and integration services.

Contact Us
INDIAN OFFICE
Hidden Brains Infotech Pvt. Ltd
405, Balleshwar Square,
Opp. ISKCON Temple, S. G. Highway,
Ahmedabad-15, INDIA
Tel.: +91-989-802-1433
www.hiddenbrains.com/

Web Development at HiddenBrains Brings Single Platform for Comprehensive Web …