Within this table I have just deleted all the passwords and when trying to log back in via phpmyadmin neither 'root' nor 'pma' users can get in. I can't work that out though as 'pma' user clearly has far less privileges granted to it when looking of the 'user' table in mysql. I know I seem to be rather talking to myself here after so many posts to myself but it seems to me and my quite newbie brain that 'pma' actually IS recognised as the root user. Traduzioni in contesto per 'valentina studio' in italiano-inglese da Reverso Context: Valentina Studio 5.2.5 Valentina Studio è il modo migliore per trasformare i dati in informazioni significative creare, gestire, interrogare ed esplorare Valentina DB, MySQL, MariaDB, Postgre e database SQLite gratis su 32/64 bit di Windows, Linux e Mac OS X. Pma user WITH skip-grant-tables gets EIGHT Root user WITH skip-grant-tables gets EIGHT Pma user when logged in with skip-grant-tables gets THREE databases To add another complexity when I use root without the password and skip-grant-tables I actually only have TWO databases. I'm quite new to mysql and actually trying to follow a tutorial on XAMPP so am keeping it specifically identical to the tutorial in the hope I might be able to reduce complexities. Going to see if via terminal I can force privileges onto that user. The current previlieges for 'pma' user (which is the root user fro phpMyAdmin) are on for: I even tried creating a new user with the same privileges as the current 'pma' user and it won't save it. Two tests using % but with nothing in the user field, and the 'pma' user for the phpmyadmin database.įrom what I can understand I need to get a wildcard '%' into the host for the 'pma' user. Try to get the info for the 'host' table and the privileges direct me to the 'db' table instead as it has a 'host' column. The latter seems mostly empty and mysql seems to have all the user data and host settings. In MySQL I have TWO databases - one called mysql and another called phpmyadmin. I've also located the mysqld.sock at /opt/lampp/var/mysql/mysqld.sock It's an empty file though is this correct? Following a suggestion on the Ubuntu forums from 2009 I attemptedĬode: Select all sudo ln -s /opt/lampp/var/mysql/mysql.sock /var/run/mysqld/mysqld.sock I've tried the XAMPP user and pword, the PMA user and pword, and ROOT user and pword. I setup the security settings in the browser for XAMPP and have saved them each in LASTPASS so I know the passwords and users are correct. I input the TCP/IP settings OR try the myqld.sock method and both are knocking me out with an error HY000: "Can't connect to MySQL server on '127.0.0.1' (107)" I'm trying to use VALENTINA STUDIO which came highly recommended on many forums. I'm trying to get access via a local GUI client though and have had trouble connecting to the database server all day. Also got them up and selectable within terminal. I managed to install XAMPP successfully on my netbook and can access it via the browser and navigate to phpMyAdmin.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |