Welcome Guest. Please Login or Register  


You are here: Index > AMPPS > General Support > Topic : I can't acces to mysql in Ampps



Threaded Mode | Print  

 I can't acces to mysql in Ampps (1 Replies, Read 11308 times)
heroj
Group: Member
Post Group: Newbie
Posts: 2
Status:
Hi,
I can't acces to mysql in Ampps-3.5-x64 on Linux mint 17.3. 
In localhost/sqlite it write:Forbidden
You don't have permission to access /sqlite on this server.

But to localhost/phpmyadmin/ I have normal root access.
In localhost/ampps - MySQL Settings - I can't change password (Could not connect to MySQL.), and can't stop Mysql in Ampps dashboard.

Before I was in Windows on Easyphp and it works, Now I'm on Linux Mint and need work on localhost.

Please help!
IP: --   

I can't acces to mysql in Ampps
Rishi_P
Group: Member
Post Group: Elite Member
Posts: 317
Status:
Reset MySQL password.

Open command prompt and run following commands.

cd /path/to/your/Ampps/mysql/bin

mysqld --skip-grant-tables --skip-networking &

nesxt open second command prompt window and run following commands.

cd /path/to/your/Ampps/mysql/bin

mysql -u root

FLUSH PRIVILEGES;

USE mysql

UPDATE user SET Password = PASSWORD('mysql') WHERE Host = '%' AND User = 'root';

FLUSH PRIVILEGES;

quit;

Now go to /path/to/Ampps/data/ folder, open my.conf file, write only mysql and save it.

Restart MySQL from Ampps control Panel.
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is April 16, 2024, 5:26 am.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.019