Howto: How to Reset the MySQL Root Password

The following procedure can be used to reset the password for any MySQL root accounts on Linux and Unix (*nix). The instructions assume that you have got the proper permissions on the host system.

Stop the MySQL daemon process

sudo /etc/init.d/mysql stop

Create a text file /home/me/mysql.sql and place the following statements in it. Replace the password with the password that you want to use

UPDATE mysql.user SET Password=PASSWORD('a_new_password') WHERE User='root';
FLUSH PRIVILEGES;

The UPDATE and FLUSH statements each must be written on a single line. The UPDATE statement resets the password for all existing root accounts, and the FLUSH statement tells the server to reload the grant tables into memory.

Start the MySQL server with the special –init-file option

mysqld_safe --init-file=/home/me/mysql.sql

Press Ctrl+C and then start the MySQL server again by /etc/init.d/mysql start and you are done.

Related posts:

  1. Howto Recover a Linux Root Password
  2. Executing SQL Statements from a Text File
  3. How to hack Windows password with Ophcrack
  4. Crack Windows Password
  5. Optimize MySQL Performance With MySQLTuner
  6. Optimize MySQL for Low Memory Use
  7. How to reset a Nokia
  8. MySQL Optimization and Performance Tips
  9. How to do MySQL replication (dual-master / multi-master)
  10. Howto: Resize Xen Loop Disk Image

Comments

How to normalize your MP3 and Flac volume levels (the right way)

Most audio software these days offer either built-in or plug-in functionality that will attempt to level the volume of your MP3 files so that you aren’t turning the volume up to hear soft songs, then getting blasted by louder ones. So why is it that even after turning that option on, you sometimes notice a significant volume difference between some songs? What’s worse is when you’re listening to songs from the same album, and the volumes jump around abnormally after applying volume normalization.

The problem is that the vast majority of audio player programs use peak amplitude analysis to determine how “loud” a song is and normalize based on that, rather than doing a more comprehensive analysis of the frequencies that impact how loud the music actually sounds. But even those that do a more comprehensive analysis fail to consider songs within the context of the album they belong to.

Luckily, there’s a great little utility called MP3 Gain that does lossless volume analysis and adjustment based on David Robinson’s Replay Gain algorithm, as well as allowing for the volume of entire albums to be processed. Radio analysis and gain adjustment will adjust all songs to the same maximum decibel level. Album mode analyzes all of the songs in an album, essentially considering them to be one entire song, then adjusts them all to a maximum decibel level, but maintains their relative volume.

Related posts:

  1. jsLogger: JavaScript logging utility
  2. Intel Releases LatencyTop 0.1
  3. Recover (Crack) a password from a Microsoft Access Database (mdb)
  4. Fedora 8 Werewolf (Screenshots)
  5. Linux Audio Editor Top 3
  6. Mirror Website Using wget
  7. Jailbreak iPhone 3GS Using redsn0w (Linux)

Comments

How To Insert SIM Card In iPhone

Comments (6)

The most common questions in a job interview

An excellent way to prepare mentally for the job is to think through some of the questions can be exposed. Many of these issues can be found on the Internet, but we have selected those we feel are most relevant. In preparing for these questions is to better the job.

Including questions can be used in several ways: It is recommended that you make this part of the preparation in two phases:

  • First reviews and thinking through your questions and possible answers for yourself.
  • Then you ask one who knows you well to practice the job through with you through the various issues.
  • That way, your ‘help’ be the guarantor of a genuine picture of you as a person and maybe even help you to answer some of the questions you are unsure about.

It may require overcoming some practice on the job in this way, but think that most professional recruitment staff also has had a job interview countless times before they performed their first job. Another good advice before we present the questions: be sure to prepare yourself on the issues and questions that you would prefer not to enter because they have a tendency to show up in most job interviews, and it’s nice to be prepared. It might feel embarrassed for you that you must speak about yourself in half to a full hour. Get over the feeling by reviewing the questions below. Review questions like sometimes to you before the conversation is sure of what you want to respond.

Questions regarding your last job / your current position

  1. Why do you want to search a new job?
  2. What responsibilities did you in your last job?
  3. What tasks did you?
  4. Describe your greatest success in your previous position?
  5. Describe your biggest failure?
  6. What tasks did you not want to work with?
  7. What tasks did you like best to work with?
  8. As most of you learned in your previous job?
  9. How do you work under pressure?
  10. Can you give examples of a situation where collaboration was not working?
  11. Can you give examples of a task or project that you are not delivered on time?
  12. Can you tell a little about how a manager should be to get the best in you?

Questions about your personality

  1. Can you give a brief description of your background / Would you tell a little about yourself?
  2. What is characteristic of you as a person?
  3. What are your strengths?
  4. What are your weaknesses?
  5. What is your main strength?
  6. What are you doing in your spare time?
  7. How would your friends describe you?

Questions concerning the upcoming position

  1. Why have you tried this particular position?
  2. What do you know our company?
  3. Why do you want to work in our business?
  4. What do you like best to work with?
  5. What is your salary?
  6. When can you take office?
  7. Why are you the right person for this job?

Other issues also could be good to look at

  1. What plans have you for the future?
  2. What child care options you have in case of illness?
  3. Give me 5 good reasons for me to hire you?
  4. When did you last read a book?
  5. Are you politically active?
  6. How long have you been seeking?
  7. How many posts have you tried?
  8. What kind of music you like best to hear?
  9. Have you ever been fired of a job?
  10. Is there something you want to know more about?
  11. Are you still interested in the job?

Issues relating to school / study (if you have no work experience)

  1. What subjects did you like best?
  2. How you saw the exam situation?
  3. Who was your best teacher – and why?
  4. If you had the opportunity to start over, what training would you choose?
  5. What is your position on the marks?

Related posts:

  1. Describe REST Web services with WSDL 2.0
  2. Bash shortcuts tips and tricks
  3. Best Practice Information Architecture
  4. What do Toyota and Linux Kernel development have in common?
  5. Crack Windows Password
  6. What is the coolest thing you can do using Linux that you can’t do with Windows or on a Mac?

Comments

Setting up your own APT repository with upload support

Comments

Awareness: Web Application Security

Developing a web applications is often articulated as easy and a good thing for new programmers to start with. Many books and tutorials have been written on the subject, and many frameworks and programming languages have been built to facilitate quick construction of web applications. Just one thing bothers me about this, many of the books and tutorials ignore many of the security issues that are related to building web applications. This fact might explain why we do have such a huge number of insecure and vulnerable web applications around on the net.

Anyway, it is not just bad – a number of initiatives have been formed to communicate the need for security and web-based applications. One of these initiatives is OWASP, which is an open-source application security project. The OWASP community includes corporations, educational organizations, and individuals from around the world. This community works to create freely-available articles, methodologies, documentation, tools, and technologies.

OWASP’s most successful documents include the book-length OWASP Guide and the widely adopted OWASP Top 10 awareness document. The most widely used OWASP tools include their training environment WebGoat, their penetration testing proxy WebScarab, and their OWASP .NET tools. OWASP includes roughly 100 local chapters around the world and thousands of participants on the project mailing lists. OWASP has organized the AppSec series of conferences to further build the application security community.

Hopefully initiatives like OWASP will provide up-coming web developers with a awareness of the security issues related to development of web application and enable them to avoid the classic pitfalls in web application security. At least so far I have learned a lot from OWASP articles and guides.

Related posts:

  1. Google Gives Away Web App Security Tool
  2. PHP Source Code Security Audit Tool
  3. 68 Linux Related Free E-books
  4. Voices That Matter: GWT – Security
  5. Test your environment’s security with BackTrack
  6. Popular Photoshop Tutorials
  7. Firefox Flash Interaction Bug: I Cannot Click In Flash Application e.g. Youtube
  8. Top 15 Free SQL Injection Scanners
  9. Howto Install Ruby and Ruby on Rails on Debian Etch 4.0
  10. Germany warns users against Internet Explorer

Comments (2)

Howto Hack a Wireless WEP Network

Comments (206)

/dev/hello_world: A Simple Introduction to Device Drivers under Linux

Comments

« Previous entries Next Page » Next Page »