That sounds tough OP.
How long have you worked there?
What is keeping you in a job that you have become so unhappy in?
If you are so bored you could cry, it is affecting your mental health and you are watching your manager giving development opportunities to someone else and not to you, I think I would be starting to ask some questions of myself, as well as my manager, I think?
Someone I know well managed a long term employee who should have moved on from their job - but didn’t. They were bored of their role (which they were not doing a great job of) - and they were highly resistant to changing their ways of working. They wanted more opportunity and responsibility, but this would not have been good for the organisation.
Can you think of any reasons (even if you disagree with them) why your manager is not giving you the opportunities you are hoping for?
Do you get on well with other members of your team? Are you consistently doing a really good job at work?
It seems important to have this conversation with your manager at this point, so at least you can be sure they know how you feel and what you think - and see if there is a way forward where your hopes and the needs of the organisation align.
Realistically, if (for whatever reasons good or bad) they don’t see you as a good candidate for development / promotion within your organisation, you’d probably be better off starting to look for another opportunity elsewhere.
Being bored and miserable at work is tough on you - but possibly also quite tough on the team and organisation you work for.
A new role and a new manager may be just what you need to thrive - and might also give your current organisation the opportunity to have someone in their team who would be happier in the role.