> *hi i have a problem with my suse studio project
> when i build my project every thing is working ok but i can't login to
> and also i cant login to mysql server from the command line
> it always say access denied for user root
> so what should i do to make enable phpmyadmin or what is the right way to
> install mysql server and phpmyadmin
> thanks and sorry about my bad english*
I do it a little bit different than the information in that link. This is how I do it:
1) Stop mysql ( service mysql stop )
2) Edit /etc/my.cnf ( vi /etc/my.cnf )
3) In there in the server section add skip-grant-tables
4) Start Mysql (service mysql start)
At this stage you will be able to login to mysql just fine (no passwords will be prompted)
Now in console:
2) use mysql;
3) insert into user (Host, User, Password) values ('localhost','root','');
4) update user set Select_priv='Y',Insert_priv='Y',Update_priv='Y',Delete_priv='Y',Create_priv='Y',Drop_priv='Y',Reload_priv='Y',Shutdown_priv='Y',Process_priv='Y',File_priv='Y',Grant_priv='Y',References_priv='Y',Index_priv='Y',Alter_priv='Y',Show_db_priv='Y',Super_priv='Y',Create_tmp_table_priv='Y',Lock_tables_priv='Y',Execute_priv='Y',Repl_slave_priv='Y',Repl_client_priv='Y',Create_view_priv='Y',Show_view_priv='Y',Create_routine_priv='Y',Alter_routine_priv='Y',Create_user_priv='Y', Event_priv='Y', Trigger_priv='Y', Create_tablespace_priv='Y' where user='root';
(All these commands are ran in mysql console or via phpmyadmin)
Now the above commands tell mysql to create root user (as it does not exists in the distribution)
And we are all set, now revert back
A) Edit my.cnf (vi /etc/my.cnf )
B) remove: skip-grant-tables
C) service mysql start
and you are done (password is blank), update a new password using
thanks a lot paulo your method succeeded with me and i can login to phpmyadmin
now i need one step more
how i can convert this steps to batch script and execute this script at the first boot
Here's the steps for having a basic MySQL database set up, running, and accessible when your appliance first boots.
1. Add the mysql-community-server and phpMyAdmin packages on the Software tab.
2. In the Server tab of the Configuration tab make sure that "Set up MySQL" is unchecked.
3. In the Scripts tab of the Configuration tab, check "Run script at the end of the build".
4. Add the following to the end of the script (replace <MySQL_Password> with what you want it to be):
chkconfig -a mysql
mysqladmin -u root password '<MySQL_Password>'
Now when you boot up your appliance, MySQL should be up and running and you should be able to log in using both the console and phpMyAdmin.