Today I got the error below :
1
| ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) |
after typing :
I don’t know why ? but I know how to solve it.
First of all let’s disable password authentication :
Stop your MySQL daemon:
or
1
| /etc/init.d/mysqld stop |
Then run the following command line in background :
1
| mysqld_safe --skip-grant-tables & |
Secondly run :
Finally, In your MySQL command line prompt issue the following command:
1
2
3
4
| USE mysql;
UPDATE user SET password=PASSWORD("my_password") WHERE user="root";
FLUSH PRIVILEGES;
EXIT |
Password is now reset to my_password. So just restart your MySQL server using :
1
| /etc/init.d/mysql restart |
or
1
| /etc/init.d/mysqld restart |
and use your new password to authenticate :
All that remains is to enter your password.
Marouan OMEZZINE Tips & Tricks, how-to error, mysql
Today when I tried to install a pear package using the pecl command line on ubuntu, I got the following error :
1
2
3
4
5
6
7
8
| pecl install pecl_http
downloading pecl_http-1.6.3.tgz ...
Starting to download pecl_http-1.6.3.tgz (173,005 bytes)
.....................done: 173,005 bytes
71 source files, building
running: phpize
sh: phpize: not found
ERROR: `phpize' failed |
Just install php5-dev package
1
| apt-get install php5-dev |
or php4-dev if you are running php 4.x
1
| apt-get install php4-dev |
Marouan OMEZZINE Tips & Tricks, how-to error, pecl, php, phpize, ubuntu
Q : What’s the best thing that may happen to a developer ?
A : A Bug 
at the beginning of the day
I ran script/console in a rails project to debug something on console, but I got this LoadError:
1
2
3
4
5
6
7
8
9
10
| Loading development environment (Rails 2.1.0)
/usr/local/lib/ruby/1.8/irb/completion.rb:10:in `require’: no such file to load — readline (LoadError)
from /usr/local/lib/ruby/1.8/irb/completion.rb:10
from /usr/local/lib/ruby/1.8/irb/init.rb:252:in `require’
from /usr/local/lib/ruby/1.8/irb/init.rb:252:in `load_modules’
from /usr/local/lib/ruby/1.8/irb/init.rb:250:in `each’
from /usr/local/lib/ruby/1.8/irb/init.rb:250:in `load_modules’
from /usr/local/lib/ruby/1.8/irb/init.rb:21:in `setup’
from /usr/local/lib/ruby/1.8/irb.rb:54:in `start’
from /usr/local/bin/irb:13 |
I figured out that some libraries are missing after installing ruby from sources (I got those troubles after upgrading my ubuntu from 8.10 to 9.04 and then reinstalling ruby from sources to solve a non-compatibility problem of the already installed ruby binary package with ubuntu 9.04) :
1
2
| sudo apt-get install libncurses5-dev
sudo apt-get install libreadline5-dev |
Then move to your ruby source folder, subfolder ext/readline and then configure, build and install stuffs.
1
2
3
4
| cd /usr/src/ruby-1.8.6-p368/ext/readline/
ruby extconf.rb
sudo make
sudo make install |
you may get something like this : ( when running ruby extconf.rb)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| marouan@myownpercept:/usr/src/ruby-1.8.6-p368/ext/readline$ sudo ruby extconf.rb
checking for tgetnum() in -lncurses... yes
checking for readline/readline.h... yes
checking for readline/history.h... yes
checking for readline() in -lreadline... yes
checking for rl_filename_completion_function()... yes
checking for rl_username_completion_function()... yes
checking for rl_completion_matches()... yes
checking for rl_deprep_term_function in stdio.h,readline/readline.h,readline/history.h... yes
checking for rl_completion_append_character in stdio.h,readline/readline.h,readline/history.h... yes
checking for rl_basic_word_break_characters in stdio.h,readline/readline.h,readline/history.h... yes
checking for rl_completer_word_break_characters in stdio.h,readline/readline.h,readline/history.h... yes
checking for rl_basic_quote_characters in stdio.h,readline/readline.h,readline/history.h... yes
checking for rl_completer_quote_characters in stdio.h,readline/readline.h,readline/history.h... yes
checking for rl_filename_quote_characters in stdio.h,readline/readline.h,readline/history.h... yes
checking for rl_attempted_completion_over in stdio.h,readline/readline.h,readline/history.h... yes
checking for rl_library_version in stdio.h,readline/readline.h,readline/history.h... yes
checking for rl_event_hook in stdio.h,readline/readline.h,readline/history.h... yes
checking for rl_cleanup_after_signal()... yes
checking for rl_clear_signals()... yes
checking for rl_vi_editing_mode()... yes
checking for rl_emacs_editing_mode()... yes
checking for replace_history_entry()... yes
checking for remove_history()... yes
creating Makefile |
Marouan OMEZZINE Tips & Tricks, Web development, how-to error, extconf, rails, ruby
Social Links